While performing remote debugging, I encountered the error message:
"Interface not registered on client . SQL Server 2005 client may not be properly installed."
Remote Debug Components are not installed or registered on the workstation running Toad. From Toad for SQL Server Support Bundle (Help | Support Bundle), it shows that the SQL Server debug registry keys are not found.
1. If you don't have a SQL Server Client installed on your workstation, then the client you want to download is located in the following Microsoft Site:
If your OS is 32-bit grab sqlncli.msi.
If your OS is 64-bit grab sqlncli_X64.msi.
2. Register your ssdebugps.dll
a. By default, go to C:\Program Files\Common Files\Microsoft Shared\SQL Debugging\ssdebugps.dll or search for where it is on your drive
b. Unregister it first. Go to Start | Run and copy and paste the following:
regsvr32 /u "C:\Program Files\ Common Files\Microsoft Shared\SQL Debugging\ssdebugps.dll"
More information on setting up Remote Debugging from Microsoft Library:
http://msdn.microsoft.com/en-US/library/y7f5zaaa(v=VS.80).aspx