Hello.

I am having problems running t-sql debugger in query analyzer. Every time I try to debug a stored procedure, it gives a message saying "The debugger interface is not installed. Please re-run setup, select 'add components to your existing installation and make sure you select 'Development Tools/Debugger Interface''...

I tried to re-run setup, but it shows the debugger as being installed. Next, I started working on the steps in 'Troubleshooting the Transact-SQL Debugger' in the Book On-line. While trying to register the file sqldbg.dll (regsvr32 sqldbg.dll) I received an error message stating "LoadLibrary ("sqldbg.dll") failed. The specified module could not be found."

Any help is greatly appreciated. Thank you, D K Spivey

Hi,

First, for registering a component into your system you should have administrative rights.

Secondly, If you have SQL server installed in your machine (local) then right click the server on EM --> click Properties --> click security tab and click the "This account" option button and give a account userid/pwd.

Hope this works.

Thanks,
Lalit