Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-11-19 : 13:12:03
|
| When I try to debug on my local machine I get the following error"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 have done this and have run the fix registry dos'nt seem to be working...I removed the everyone account from my machine. Would this be the cause of the impact, What security rights does the Debugger run under. I am an Administrator on my local machine. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-19 : 13:13:44
|
| In SQL Server Books Online, check out the topic entitled "Troubleshooting the Transact-SQL Debugger".Tara |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-11-19 : 14:05:03
|
I modified the SQL Debugger Registry2 Properties and change the Identity from SqlDebugger to myself. This now runs the debugger but the debugger gave me the following message:Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on MSB-ACC306P-01 (Error = 0x80070057). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on MSB-ACC306P-01. Debugging disabled for connection 54.I ran regsvr32 for this component and still get the error message.Hmmm... So I did the following steps:1. Make sure you have permission to execute the SP_SDIDEBUG extended procedure.2. Start the SQL Server Service using an account that has Administrator privileges on that computer.3. Check the Event Viewer's Application and System logs for any error messages. The Application Error Log says:Error: 508, Severity: 16, State: 1Unable to connect to debugger on MSB-ACC306P-01 (Error = 0x80070057). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on MSB-ACC306P-01. Debugging disabled for connection 54.I have checked my Symantic Firewall and my IP is in my Trusted Connections, Nothing shows up in the logs indicating this Port is blocked...Assistance would be appreciated, I will continue seaching the BOL in the meantime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-19 : 14:18:19
|
| Sounds like you've got MDAC problems.Tara |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-11-19 : 14:25:30
|
| Yea mabe I just ranExec sp_sdidebug 'legacy_on' --This did nothingHmmm... I'll Check into MDAC... |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-11-19 : 14:46:14
|
| I tried updating the MDAC to the version included in Service Pack 3a... Did not work, However running Sp3a did work...sp_server_info says:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) How can I check the MDAC version? |
|
|
|
|
|
|
|
|
Query Analyzer Debug Interface Error