-
Title
Getting error "Unable to register debugging on the server" when trying to debug. -
Description
I am trying to debug a store procedure in Toad and is getting the error "Unable to register debugging on the server". I ran the Debug setup wizard and it said successful. I then set the parameters, set the stops and ran it.
Other possible error message:
System.Exception: Review the help file to ensure "servername" is configured for debugging.
Error message: Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED) -
Resolution
Check to see if you are able to connect to the server using Windows Authentication from the login screen. if not, create a Windows Authentication by running the script below in the editor window:
sp_addservrolemember 'domain\name', 'sysadmin'.Go to the Object Explorer | Server Securities and hit Shift + F5 to refresh the list and verify if the user has been added.
Can be found in Help | Content | Edit SQL | Debug SQL | Configure SQL Server Debug.