By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,442 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

cannot debug stored procedure msg - db not setip or permission prob ?

P: n/a
Hi,

I followed everything this article suggests:

http://support.microsoft.com/default...b;EN-US;836734

Yet I still get the following message when stepping into a SP:

"Cannot debug stored procedures because the SQL server database is not setup
correctly or the user does not have permission to execute
master.sp_sdidebug. Run SQL server setup of contact database administrator"

Im using:
- windows xp
- vs .net 2003
- 2003 domain
- sql 2000 running on 2003 member server

Also domain users added to SQL server USERS, REMOTE DESKTOP USER, DEBUGGER
USERS, VS DEVELOPER USER groups + CREATE GLOBAL OBJECT policy (server also
reboot).

Many thanks for any help
Scott

cannot debug stored procedure msg - db not setip or permission prob ?
Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
in addition i have,

1. component services, my comp, properties, default com security - allowed
access for domain users

2. create global object local policy allowed by domain users.

3. sql startup service account is a local admin

reboot.

Scott
Nov 22 '05 #2

P: n/a
way hey !!!

FIX: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2

sql 2000 standard
..net 2003 enterprise architect
xp sp4

install SP4 for SQL sorted it.

Cheers
Scott
Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.