SQL Debugging: Unable to start T-SQL Debugging. Could not attach to SQL Server process
Error Message
Unable to start T-SQL Debugging. Could not attach to SQL Server process
This topic applies to:
Visual Studio Ultimate |
Visual Studio Premium |
Visual Studio Professional |
Visual Studio Express |
|---|---|---|---|
.gif "ms241738.DoesApplybmp(en-us,VS.100).gif") |
|
|
.gif "ms241738.DoesNotApplybmp(en-us,VS.100).gif") |
This error occurs when the Visual Studio debugger cannot register the user with the database server for debugging. The most likely cause is the lack of necessary permissions on the instance of SQL Server. Connecting the Transact-SQL editor to the server with a login having the sysadmin fixed server role is not sufficient; the Windows login of the Visual Studio user must also be a member of the sysadmin fixed server role on that instance of SQL Server.
For more information, see How to: Enable Transact-SQL Debugging