Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

After SP2 I was unable to connect to MS-SQLServer 2008. I found that Sql Server Browser service was stopped. I enabled Browser but it did not help. Everything was fine before SP2? Anyone had similar problems. My OS is Windows 7 64.

Edit: Protocols for MSSQLSERVER: Enabled Shared memory, Named pipes and TCP/IP

Under TCP/IP, all settings seam OK.

Connection fails from local network to this computer, otherwise server working OK.

share|improve this question

The Browser service doesn't enable connectivity, it assists in locating and connecting to SQL instances. I would check to see which protocols are enabled in SQL Server Configuration Manager.

share|improve this answer
I would give you a vote up but i have not enough reputation here, sorry. You can update answer with firewall and i will make it green because you helped in solving this. – watbywbarif Dec 16 '10 at 7:38
up vote 0 down vote accepted

Windows firewall exception was removed after MS-SQL-SERVER SP2. All working fine after I added exception.

share|improve this answer
Please mark this as the correct answer (there's a white checkmark to the left of this Answer, click it and it will turn green). – Chris S Dec 16 '10 at 16:07
I know how to make question answered ;) I have experience at Stackoverflow and other, but as I am new here and can't vote up to thank the contributor, i gave him a chance to update answer so that he gets some points for helping ;) – watbywbarif Dec 17 '10 at 8:16
Oh and I have to wait 7h to accept my answer??? – watbywbarif Dec 17 '10 at 8:20

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.