Been using SQL Server Management Studio (SSMS) without errors. After successfully installing Toad for SQL Server, whenever launching SSMS the following error occurs:
Toad for SQL Server:Type Load exception
TypeLoadException. Could not load type.
'Microsoft.sqlserver.management.sqlstudio.explorer.objectexplorerservice' from assembly...
WORKAROUND 1:
Uninstall the SSMS add-on.
1. Fully exit all Toad instances.
2. Run command prompt (CMD) with administrator privileges.
3. Change directory to the "SSMS Installation" subfolder within the Toad's installation directory:
For example, type in CMD:
* 64-bit Machine - cd "C:\Program Files (x86)\Quest Software\Toad for SQL Server 6.1\SSMS Installation"
* 32-bit Machine - cd "C:\Program Files\Quest Software\Toad for SQL Server 6.1\SSMS Installation"
4. Execute the following command in the CMD:
* 64-bit Machine - SsmsInstallation.exe Uninstall "C:\Program Files (x86)\Quest Software\Toad for SQL Server 6.1"
* 32-bit Machine - SsmsInstallation.exe Uninstall "C:\Program Files\Quest Software\Toad for SQL Server 6.1"
5. Start Toad and retest the issue.
WORKAROUND 2:
1. Fully exit all Toad instances.
2. In the Registry (Run | type: regedit), navigate to the following location:
* 64-bit Machine - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\100\Tools\Shell\AddIns\Dell.Toad.SSMSAddin35.Connect
* 32-bit Machine - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\AddIns\Dell.Toad.SSMSAddin35.Connect
3. Rename the "Dell.Toad.SSMSAddin35.Connect" by adding "_OLD" in the name.
(i.e.: Dell.Toad.SSMSAddin35.Connect_OLD)
4. Start Toad and re-test the issue.
STATUS:
This issue has been fixed in Toad for SQL Server version 6.2. The latest version of Toad for SQL Server can be downloaded here.
*****Windows Registry Disclaimer*****
Dell Software does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support.
