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

Currently I have SQL Server running on a local machine and it is working. However I would like to connect to it with my other machines on the network. The other machines do not see this SQL Server. Do I need to configure the sever to allow remote connections? If so how can I do ths and where. Thank you.

share|improve this question
Is this the express edition, or one of the "full" flavours? – Mark Henderson Apr 28 '12 at 23:01
This is express edition. – Brandon Wilson Apr 29 '12 at 0:25
up vote 1 down vote accepted

It should be listening by default I believe, but I suspect the Windows firewall is not permitting the connections. Go to Control Panel, Windows Firewall, along the left side is a task/wizard for letting an application through in a specific zone that will build the more complex rules for you.

If however SQL server is NOT already listening, then someone with more experience will have to help you.

share|improve this answer

1.Check your sql server browser is running or not if it is stopped start sql browser. 2.May be your windows firewall is blocking,if you are using default port 1433 allow the port.

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.