Running SQL Server Management Studio as administrator

If you start SSMS as administrator on a Windows 7 machine with UAC on, you get Class not registered "Error number: 80040154" for the TabsStudio.Connect class:

Class not registered error 80040154 in SSMS

Tabs Studio installation for SSMS includes registration of the TabsStudio.Connect class for the current user. On a Windows 7 machine with UAC enabled, elevated applications (in this case SSMS running as admin) don't see registered per-user COM classes. A workaround is to register TabsStudio.Connect per-machine manually, double clicking a prepared registration file.

SSMS is a 32-bit application. Running on 32-bit Windows it uses per-machine COM registration from HKEY_LOCAL_MACHINE\Software\Classes\CLSID, on 64-bit Windows - HKEY_LOCAL_MACHINE\Software\Classes\WOW6432node\CLSID. Run one of the following registration files depending on your version of Windows:
TabsStudio.Connect registration for 64-bit Windows,
TabsStudio.Connect registration for 32-bit Windows.

Note that after unsuccessful loading SSMS 2008 disables Tabs Studio and doesn't try to load again on a next start. To enable Tabs Studio startup loading you can reinstall Tabs Studio or change HKCU\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Addins\TabsStudio.Connect\LoadBehavior from 0 to 3.

Return to User Guide