Toad World® Forums

7.2 debug setup error messages and fixes

here is the detailed output of the debug setup wizard. As promised it tells you what is missing on the server and the client..... wait for it

BUT NOT HOW TO FIX THEM !!!!!!!!!

my data follows

Error: Client: sqldbg.dll COM library is not registered.
Registry sqldbg.dll COM library.

Error: Client: sdiclnt.dll COM library is not registered.
This library should be registered for debugging.

Error: Client: sqldbreg2.exe path was not found.

Error: Client: sqldbreg2.exe is not registered properly.

Client: Distributed COM on the client is enabled
Distributed COM application should be enabled in Component Services.

Client: OS version:Microsoft Windows NT 6.2.9200.0

Server: Connection to the server successful

Server: Microsoft SQL Server 2017 (RTM-CU21) (KB4557397) - 14.0.3335.7 (X64)
Jun 12 2020 20:39:00
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Home 10.0 (Build 19044: )

Warning: Server: Registry path not found: 'SOFTWARE\Microsoft\MSSQLServer\Setup'

Server: SQL Server 'WMS-HP-PC' SQL Server account: 'NT Service\MSSQLSERVER'
In some cases SQL Debugging not work properly with Local System account of SQL Server

Server: Distributed COM on the server is enabled
Distributed COM application should be enabled in Component Services.

Error: Server: sqldbg.dll COM library is not registered.
Registry sqldbg.dll COM library.

Server: User connection to the server successful

Error: Server: SQL Server 2000 Debugger failed to start
Specified cast is not valid.

Might need to contact Support for this one, but before you do, your firewall settings may be contributing to the effect here... see KB article on Quest support site here:
https://support.quest.com/toad-for-sql-server/kb/49401/internal-debugger-setup-wizard-stops-with-sql-server-200-debugger-failed-to-start