Post reply

SQL Query Analyzer: Debugger doesn''t work

  • April 30, 2007 at 10:46 am

    #95299

    When I try to debug, I get 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 IBM (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on WS-IGNACIO. Debugging disabled for connection 54.

    How can I solve this?

  • April 30, 2007 at 12:21 pm

    #703374

    It's been awhile, but I think this has something to do with security. Either your user or the SQL Server user do not have administrative rights needed for debugging.

  • May 1, 2007 at 6:27 am

    #703512

    Grant execute on sp_sdidebug to your user.  One of the service packs changed permissions on this stored procedure.

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

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