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

S

scott

Hi,

I followed everything this article suggests:

http://support.microsoft.com/default.aspx?scid=kb;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 ?
 
S

scott

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
 
S

scott

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top