Post reply

Debugger fails to communicate with SQL Server

  • September 9, 2005 at 10:47 am

    #88972

    I get the following error when trying to run the 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 OK1 (Error = 0x80070005). Debugging disabled for connection 54.

    This happens the first 3 or 4 times I try to run the debugger, then suddenly, at the next try it runs correctly.  From then on there's no problem, until the next time I load SQL Query Analyzer.

    How can I fix this nuisance?

    Thanks in advance,

    Xavier Castillo

  • September 9, 2005 at 11:13 am

    #588809

    xavier - here's a link from another site that you may find helpful!

    link







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 14, 2005 at 6:21 pm

    #589977

    I tried "Exec sp_sdidebug 'legacy_on'" several times and it did not work.  But if I go to Enterprise Manager and expand the nodes listed below, then the problem with the debugger in Query Analyzer is fixed.  This is an empirical solution, but it seems to work, although I don't know why.

    + Microsoft SQL Servers

      + SQL Server Group

        + (local) (Windows NT)

          + Databases

    Thanks a lot,

    Xavier Castillo.

  • September 14, 2005 at 6:34 pm

    #589978

    whatever works I guess! Thanks for posting this - I'm sure it'll come in handy to someone else looking for serendipitous solutions!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply