Wednesday, February 25, 2009

Unable to start T-SQL debugging. could not attach to sql server process in sql server 2008

This error occurs when the debugger cannot register the user with SQL Server 2005 for debugging. 

The most likely cause is the lack of necessary permissions on the SQL 2005 instance. Connecting with system administrator to SQL Server is not sufficient; the Windows login of the Visual Studio user must also be a member of the system administrator role in SQL Server.