Home > IT Answers > SQL Server > Connecting to a SQL Server 2005 database thro...
Providence
15 pts.
0
Q:
Connecting to a SQL Server 2005 database through LAN
SQL Server 2005, SQL Database, SQL Server Management Studio 2005, SQL Server 2005 connectivity
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 IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either
ASKED: Jun 15 2009  9:06 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jun 15 2009  9:58 AM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Troy Tate   0 pts.  |   Jun 15 2009  11:47AM GMT

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.

 

Providence   15 pts.  |   Jun 15 2009  12:05PM GMT

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

 
0