cannot debug stored procedures via VS 2003 - get error when trying ?

S

scott

xp pro
vs 2003 enterprise arch
2003 server with sql 2000

From xp pro and when using the to "step into stored procedure" option upon
connection to a database in VS 2003 im getting the message:

" cannot debug stored procedures because the SQL server database is not
setup correctly or does not have permission to execute <stored procedure
name>. Run SQL server setup or contact database administrator ".

- my user has beed added to the "Debugger Users" and "VS Developers" user
group on the SQL server.
- remote components have been installed on the SQL server.

Does anyone know what this errors means and how to setup remote debugging
correctly ?

Many thanks
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

Members online

Forum statistics

Threads
473,994
Messages
2,570,223
Members
46,813
Latest member
lawrwtwinkle111

Latest Threads

Top