-
Title
Error, "Please contact your server administrator to configure server permissions" when trying to -
Description
Encounters an error "Please contact your server administrator to configure server permissions, during debug of a stored procedure within Toad.
"Unable to register with Server.
Please contact your server administrator to configure the server permissions.
Exception from HRESULT: 0x80070005(E_ACCESSDENIED)"or
"Unable to register debugging on the server.
Review the help file to ensure "<database instance name>" is configured for debugging.
Error message: Exception from HRESULT: 0x8000FFFF(E_UNEXPECTED)."
-
Resolution
RESOLUTION 1:
Verify that your specific debug environment is supported by Toad. This information is found in the release notes for the corresponding Toad version. This Release Notes can be found online at https://support.quest.com/Search/SearchDocumentation.aspx. In Release notes look under "Debugging Requirements"RESOLUTION 2:
Verify with the server administrator that you have server permissions for debugging and full SQL Server debug requirements.RESOLUTION 3:
Please run the Debugger Setup Wizard from the Toad's Debug menu to confirm that all the necessary SQL Server debug components are properly installed.RESOLUTION 4:
Verify if a Windows Update done recently. One may need to reset one's security and unregistered the ssdebugps.dll.RESOLUTION 5:
Verify firewall setup to make sure it's not blocking ports and ways for communication.