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.