Microsoft has published an article regarding SQL Server and Service Pack 2.
I have disabled the firewall and still cannot debug stored procedures even through the Query Analizer (which I could do before).
I keep getting the error:
“Unable to connect to debugger on SS2K (Error = 0x80070005). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on SSClient. Debugging disabled for connection 100.
It took me some time to find the article the explains the Win32API to determine the service pack level.
Why does System.Environment.OSVersion publish this information?
Was it available on early beta versions of .Net framework?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;304721
I have just installed Service Pack 2 For WinXP on my computer.
Service Without Components works great using System.EnterpriseService.ServiceDomain.
It also works with my old patch which used the Win32API to config the COM+ context.
I had to enable Network DTC Access for COM+ transactions which uses SQL Server on another machine. Just like on Win2003 server.