Showing posts with label maching. Show all posts
Showing posts with label maching. Show all posts

Thursday, March 22, 2012

(2000) Unable to connect to debugger

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?

J. Jespersen
DenmarkJeppe Jespersen (jdj krlledims jdj punktum dk) writes:

Quote:

Originally Posted by

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

(2000) Unable to connect to debugger

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?
J. Jespersen
DenmarkThe files might be corrupted or you don't have permission for the program. T
o
check the permission check the sp_sdidebug.
"Jeppe Jespersen" wrote:

> 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 conne
ct to debugger
> on MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side components,
> such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disabl
e
> for connection 53."
> Client side components _are_ installed. What gives? Any ideas?
> J. Jespersen
> Denmark
>
>
>