Connecting to a SQL Server 2005 database through LAN
I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESSSERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either
Software/Hardware used:
Software/Hardware used:
ASKED:
June 15, 2009 9:06 AM
UPDATED:
March 5, 2011 8:41 AM
I figured out my problem.
I'm ashamed to admit that the solution was rather simple, but I think my Google search keywords were bad
I hadnt set the server to allow remote connections : /
This can be done by running surface area configuration (Start » Programs » Microsoft SQL Server 2005 » Configuration Tools) and going to configuration for services and connections, and then under remote connections selecting local and remote connections.
Could have sworn I had this enabled but what ever
Other Answers:
If you are using the IP Address to connect to the SQL Server you don’t need to include the server name. Just use the IP Address.
but this Dosen’t work either….
To see other answers submitted to the Answer Wiki: View Answer History.
Be sure the SQL service is running on the server. You can also check at a cmd prompt to see if the server is listening on port 1433. Type netstat -a | find “LISTENING” . This will return a list of all of the listening ports on the server. If port 1433 (standard SQL port) is not shown then either the service is listening on another port or the service is not running.