Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.