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.

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

2 Answers

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.

http://msdn.microsoft.com/en-us/library/ms181087.aspx

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