Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

How to: Set Permissions for Debugging on SQL Server 2000

This topic applies to:

Visual Studio Edition

Visual Basic

C#

C++

J#

Visual Web Developer

Express

No

No

No

No

No

Standard

No

No

No

No

No

Pro/Team

Yes

Yes

Yes

Yes

Yes

To debug on a SQL Server 2000, you must have permission to execute the extended stored procedure sp_sdidebug. You must also own any stored procedures you want to debug.

To grant permission to execute the extended stored procedure sp_sdidebug, you can use the Enterprise Manager, which ships with SQL Server 2000, or consult your database administrator.

The following code shows an example of how to grant sdidebug permission to a user:

EXEC sp_grantlogin 'mydomain\myusername'

EXEC sp_grantdbaccess ' mydomain\myusername', 'Myname'

GRANT EXEC ON sp_sdidebug TO Myname

in database 'master'

For Windows NT 4.0 only, you must perform the following steps.

NoteNote

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To set up SQL Server 2000 for debugging for Windows NT 4.0

  1. On the Start menu, click Settings, and then click Control Panel.

  2. In Control Panel, click Services.

  3. Select MSSQLServer, and then click Startup.

  4. Select the Log On As check box. If the option is set to System Account, change it to This Account, type the valid domain and user account in the form domain\account, of a user with administration privileges, such as the administrator on the local SQL Server machine, and then enter the password.

  5. If you have changed the settings, restart SQL Server.

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.