SQL Server Performance Forum – Threads Archive

sql debugger

Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate with debugger on DBTESTDEV (Error = 0x80070005). Debugging disabled for connection 56. i ran the:
Exec sp_sdidebug ‘legacy_on’ also gave exec to that sp above(sp_sdidebug)
restarted the sql engine.
still same error. any ideas?

---

You have to rerun that query everytime you restart sql server. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;328151 for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

i have tried all this. still does not work.
same error.

---

Is it a production SQL server?
If so what is the level of service pack on Server & Client? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Which OS and service pack are you running?

---

If this works: i ran the:
Exec sp_sdidebug ‘legacy_on’ Then he is running an older version of SQL Server on a new OS such as 2003. He will have to: 1. Upgrade SQL Server to the latest version/service pack, or
2. Run this everyime he starts SQL Server. There’s no magic way around it. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

]]>