0

I have installed SQL server 2008 in one of my machines, and i am trying to access the server from a different machine within the same network, and for some reason it cant connect to the server. I allowed remote connections to the server, and added the ports to windows firewall.. is there anything else needs to be done?

thanks

3 Answers 3

1

What are you connecting with and what is the error you're getting? Are you trying to use SQL Server Management Studio?

Make sure the SQL Browser Service is running on the server

Make sure TCP/IP is enabled on your client's SQL Native Client configuration.
1. Open SQL Server Configuration Manager
2. Expand SQL Native Client Configuration
3. Click Client Protocols, make sure TCP/IP is enabled

Also, make sure you've got the right port(s) open on the firewall (I know you said you already have the port open). Default is TCP/1433. This can be changed, though, and if you're using a named instance you will probably need to assign it a static port and add it to the firewall config.

2
  • this is what i get now..provider:names pipes provider: error 40-couldnt open a connection to sql server
    – Papillon
    Sep 18, 2009 at 3:31
  • Ok, try this then. Go back into SQL Native Client configuration as in steps 1-3 in my answer above and make sure TCP/IP is the first protocol in the list (it's an ordered list).
    – squillman
    Sep 18, 2009 at 11:31
0

Can the other machine see the SQL Server's host machine? Try a ping on name, then IP if the name doesn't respond.

0

Changes to the networking protocols only take place upon the service restarting. Hopefully this isn't a doh moment.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .