Share via


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

ms241738.DoesApplybmp(en-us,VS.100).gif ms241738.DoesApplybmp(en-us,VS.100).gif ms241738.DoesApplybmp(en-us,VS.100).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

See Also

Reference

Transact-SQL Debugging Setup Errors and Troubleshooting