Debugging is not working.
Posted: Mon 22 Apr 2013 18:56
I attempt to step through a stored proc using dbForge for MSSQL. The server version of MSSQL is 2012.
I get a simple and not very descriptive message: Error debug initiialization
Clicking help reveals two basic requirements:
1) User must be connected via Windows or SQL authentication and must be a member of sysadmin fixed server role. (I have logged in as both SA and Windows Authentication. I am a member of the Domain admins on the network level and I am a member of the sysadmin linked role on the server. [ select IS_SRVROLEMEMBER ('sysadmin') returns 1 ] )
2) database engine must be version 2005 or greater. (MSSQL 2012)
So it appears I meet the requirements but it still does not work.
Do you guys have a sql proc we can run to check for some issues? Is there a better detailed help that steps me through the procedure of preparing a user/database for debugging or links to an article?
I get a simple and not very descriptive message: Error debug initiialization
Clicking help reveals two basic requirements:
1) User must be connected via Windows or SQL authentication and must be a member of sysadmin fixed server role. (I have logged in as both SA and Windows Authentication. I am a member of the Domain admins on the network level and I am a member of the sysadmin linked role on the server. [ select IS_SRVROLEMEMBER ('sysadmin') returns 1 ] )
2) database engine must be version 2005 or greater. (MSSQL 2012)
So it appears I meet the requirements but it still does not work.
Do you guys have a sql proc we can run to check for some issues? Is there a better detailed help that steps me through the procedure of preparing a user/database for debugging or links to an article?