I was thrilled to get my hands on the Win XP SP2 . Installed it yesterday night and first thing in the morning, my team members come up to me saying that they cannot access SQL Server 2005 instance on my machine (my machine doubles up as the test server for MS SQL Server 2005). Checked whether the service was running and it was ... thought about SP2 breaking the SQL Server installation.
Was going to uninstall and install the Yukon Bits again , when I came across an article somewhere which pointed out that SP2 caused problems with some 50 programs and SQL Server being one of them. It also said some thing about the XP firewall system. Checked out and found that the Firewall did not grant access to SQL Server from across network. It did not even feature SQL server in the list of programs that it shows and so I had to go and grant access to sqlserver.exe from the SQL server directory.
Phew !!! Just about prevented another 4 hours of work uninstalling and reinstalling SQL Server 2005 bits.