Snap-in when running SQL EM

[syscare]

When we try and run Sql Enterprise Manager we get the following error -

Snap-in failed to initialize.
Name: -not available-
CLSID: {00100100-1816-11D0-8EF5-00AA0062C58F}

We can run this fine from the SQL server, but we have shortcuts to it on our Citrix servers and this is where we experience the problem.

I have tried recreating the shortcut and I have installed another instance of SQL EM on another drive, but still I get the same problem.

This has worked in the past, any ideas ?

Thanks
Dave

 

[JayKusch]

1. Search "My Computer" for SQLSRV32.DLL.
2. While The C:\WINNT\system32\SQLSRV32.DLL version and date is the one to consider,
the other folders/locations with matching dates/versions may offer a clue as to
what software may have installed an older version of SQLSRV32.DLL on top of the
newer version.
3. Compare the C:\WINNT\system32\SQLSRV32.DLL date & version file properties with
the one in the SQL Server 2000 CD.
4. Whether SQLSRV32.DLL on the box is older or not, check the MDAC install using [u-
rl="

http://www.microsoft.com/data/download.htm#CCinfo"

]

http://www.microsoft.com/-

data/download.htm#CCinfo[/url] and note the version.
5. Install/upgrade MDAC (http://www.microsoft.com/data/download.htm"]

http://w-

ww.microsoft.com/data/download.htm[/url]), preferably using a version >= the
version reported by step 4.
6. Verify version again following by following step 3 again. Try SQL Server
Enterprise Manager again

If there is a clsid associated with the snap-in failed to initialize message:
7. Start|Run|Regedit
8. Select HKEY_CLASSES_ROOT
9. Edit|Find|
10. Under that key is an InProcServer32 value which contains the DLL file name
11. Start|Search for that DLL, note the path to it
(C:\somefolder\somesubfolder)
6. Start|Run|cmd.exe
7. At the command prompt, run
C:\>REGSVR32 /u C:\somefolder\somesubfolder\.DLL
D:\>REN C:\somefolder\somesubfolder\.DLL *.questionable
8. Copy the same DLL from the SQL Server 2000 CD to the same
C:\somefolder\somesubfolder
9. Remove the Read-Only file attribute Property (via right-click on the file
in Explorer)
10. Back at the command prompt, run
C:\>REGSVR32 C:\somefolder\somesubfolder\.DLL Try SQL Server Enterprise
Manager again

You and/or a coworker who is a Local Administrator should see if you (and/or the
Administrator) can add SQL Enterprise Manager (to mmc as a snap-in) by:
1. Start|Run|mmc.exe
2. Console|Open|C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server
Enterprise Manager.MSC

If the above 2 steps fail, try:
3. Start|Run regedt32
4. Select the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer key
5. Security|Permissions, and make sure your account has Full Control to that key and
all subkeys. Try SQL Server Enterprise Manager again

If the above three steps fail, try:
6. Via explorer, rename SQL Server Enterprise Manager.MSC to SQL Server Enterprise
Manager.MSC.questionable
7. Copy SQL Server Enterprise Manager.MSC to the same \binn from the SQL
Server 2000 CD
8. Remove the Read-Only file attribute Property (via right-click on the file
in Explorer)
9. Try the above two steps again

If registry permissions didn't resolve the issue, try re-registering the following
DLLs using regsvr32: sqlns.dll sqlmmc.dll sqllex.dll sqldmo.dll dtsui.dll Try SQL
Server Enterprise Manager again

If re-registering all the above DLLs fail, then you could try copying them from the
CD (as done in the above 4 steps), but, at this point it will be much faster to
reinstall the client tools via the CD. Backup your databases first.



Thanks

J. Kusch