Posted by Erland Sommarskog on 07/18/06 19:08

Jeppe Jespersen (jdj krølledims jdj punktum dk) writes:
> On my development maching, I have three different SQL Server instances:
>
> .\SQL2000
> .\SQL2005EXPRESS
> .\SQL2005
>
> When i try to debug a stored procedure in Query Analyzer, I get the
> following error:
>
> "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 MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side
> components, such as SQLLE.DLL, are installed and registered on MYPC.
> Ddebugging disable for connection 53."
>
> Client side components _are_ installed. What gives? Any ideas?

Which service pack of SQL 2000 are you running, and which OS do you
have?

If you are running Windows XP SP2, you should upgrade to SP4 of SQL 2000.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]