Current location: Hot Scripts Forums » Other Discussions » Database » [SOLVED] Mssql


[SOLVED] Mssql

Reply
  #1 (permalink)  
Old 02-19-08, 07:34 PM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
 
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
[SOLVED] Mssql

Hey,

I have SQL SERVER setup and running. But when I connect to it it says: Unable to connect to server: localhost.

Could someone tell me why this could be?
Reply With Quote
  #2 (permalink)  
Old 02-20-08, 09:29 AM
digioz's Avatar
digioz digioz is offline
Community VIP
 
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,171
Thanks: 3
Thanked 9 Times in 9 Posts
Did you:
  • Check "Control Panel > Administrative Tools > Services" to make sure SQL Server is up and running?
  • Do you know if you have a firewall blocking the SQL port?
  • Can you ping the SQL Server from Command Line?
__________________
Reply With Quote
  #3 (permalink)  
Old 02-20-08, 09:39 AM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
 
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
The SQL Server would be my localhost ip address?
Reply With Quote
  #4 (permalink)  
Old 02-20-08, 10:33 AM
digioz's Avatar
digioz digioz is offline
Community VIP
 
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,171
Thanks: 3
Thanked 9 Times in 9 Posts
If you are running the SQL Server locally then there is no point pinging it ... lol

the 3rd one applies only if you are running the SQL Server remotely. Check the other two.
__________________
Reply With Quote
  #5 (permalink)  
Old 02-20-08, 11:59 AM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
 
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
The thing is Iam tring to get mssql working with php. But it keeps saying when I connect using: mssql_connect(); that: Unable to connect to servr: localhost
Reply With Quote
  #6 (permalink)  
Old 02-21-08, 09:04 AM
digioz's Avatar
digioz digioz is offline
Community VIP
 
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,171
Thanks: 3
Thanked 9 Times in 9 Posts
Quote:
Originally Posted by blinn_shade View Post
The thing is Iam tring to get mssql working with php. But it keeps saying when I connect using: mssql_connect(); that: Unable to connect to servr: localhost
Are you able to Query your SQL Server directly through SQL Management? If yes then post your PHP code here so we can have a look at it.
__________________
Reply With Quote
  #7 (permalink)  
Old 02-21-08, 09:51 AM
blinn_shade's Avatar
blinn_shade blinn_shade is offline
Aspiring Coder
 
Join Date: Aug 2007
Posts: 540
Thanks: 0
Thanked 0 Times in 0 Posts
Its working now. My cousin came around and set it up.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL to MSSQL questions phpdoctor Database 4 12-05-07 01:13 PM
MSSQL Query djwayne_2004 PHP 10 06-09-06 10:52 AM
php and mssql aprogrammer PHP 2 07-26-05 03:29 AM
PHP & MSSQL. Script Problem, Works on localhost but not online Lucas PHP 2 10-03-04 01:34 PM
A good online MSSQL database editor MadDog Script Requests 2 08-18-03 08:55 PM


All times are GMT -5. The time now is 05:02 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.