SQL Server 2000 - unable to debug

Posted on 2007-07-24
Last Modified: 2008-09-19
I get the following message when i try to debug using SQL Server 2000:

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 EMBRYONDEV02 (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on 8TT4M81. Debugging disabled for connection 125.

I tried copying over all of the necessary dll's: sqlle.dll, sqldbg.dll, mssdi98.dll, and sqldbreg2.exe to the binn directory, but still getting this error.  I've tried using this: as a guide, but it hasn't worked and I still can't debug.  I have .net 2003 installed on the same computer.

I haven't been able to debug in over a year.
Question by:Kaporch
    LVL 16

    Expert Comment

    Look through this article and see if anything applies:

    Author Comment

    I found 2 sqlservr.exe on my computer, one in path c:\sqlksp4\x86 \binn and c:\program files\microsoft sql server\mssql\binn.  The sp4 has a date modified of 5/4/2005, the other 8/6/2000.  I think the sp4 was installed when I ran service pack 4 on my computer, but I'm not sure if I should delete one of them or copy the dll files to both directories.

    Author Comment

    Actually, what I needed was to become adminstrator on my computer, and also not to use the anonymous login but synchronize my SQL Server password with the windows password.
    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Read about achieving the basic levels of HRIS security in the workplace.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now