Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
savesheep
Starting Member
2 Posts |
 Posted - 2009-03-30 : 21:21:58
|
| I have MSSQL 2005 set up on a SBS 2008 server. I've gone into the surface area configuration tool to enable remote connections via both tcp/ip and named pipes. I've started the SQL Browser as well.I also logged into SQL Server Configuration Manager to make sure everything is enabled. In here I enabled the VIA under protocols for SQL Server 2005 Network Connections.The firewall is disabled on this machine. My program will not connect to the mssql database as i'm getting the error saying connection refused."A network-related or instance-specific error occurred while establishing a connection to SQL Server. THe server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."SOO for some reason I can't connect to it. When I run netstat -a on the server I get hundreds of pages so I can't exactly see if port 1433 is listening. Is there another way to check? Is there a program I can download that specifically tests connections to MSSQL?Last but not least - I have configured the router to push port 1433 to the local IP of the server. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
savesheep
Starting Member
2 Posts |
Posted - 2009-03-31 : 08:43:08
|
| Hey Tara,Thank you for the link! I tried to telnet and I get this error:Could not open connection to the host on port 1433: Connect Failed.Thanks!-Shea |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
how do i make sql 2005 allow remote connections?