Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am having problems making my ms sql server 2008 take remote connections, local workes fine.

  • I have enabled the TCP/IP and the server browser server in the sql server config
  • I have opened the ports in the firewall, have also tried shutting it down completly.
  • I have made it so the server allow username/password logins.

What am i missing for remote connections to be allowed? The Sql Server 2008 R2 is running on windows 7.

share|improve this question

What error do you get?

I'd probably try disabling the Named Pipes protocol first to see if that makes a difference, since it always seems to cause me problems, check the SQL server and instance aliases to make sure they're correct, verify that your SQL server is listening on the default port (1433), and after that, consult a SQL connectivity troubleshooting guide and/or my logs. This is where error information would come in handy, because for all we know from what you've given us, the problem is that someone took a hammer to the NIC in your SQL box.

By the way, did someone take a hammer to the NIC in your SQL box?

(And, incidentally, why are you running SQL on Windows 7? Icky.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.