SQL Server Installation in XP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server Installation in XP

Author

Topic

rpc86
Posting Yak Master

200 Posts

Posted - 2006-12-12 : 22:42:46

Hi there,

I installed SQL Server 2000 in my Windows XP Professional 2002. Before the installation finished, there was an error message about the HHCOL.EXE, I don't know this file. I restarted my computer then I tried to go to Enterprise Manager to start creating Database but there was a promp message saying:

"Snap-in-failed to initialize.
Name:Microsoft SQL Server Enterprise Manager
CLSID: {00100100-1816-11D0-8EF5-00AA0062C58F}"

What does it mean?

I installed several times in Windows XP for SQL Server 2000 but this is my first time to encounter this problem. The SQL Service Manager works fine (Services:SQL Server). Our server name has the maximum lenght of 15 characters long.

What should I do?

Please help.

Thanks

monty
Posting Yak Master

130 Posts

Posted - 2006-12-12 : 23:09:48

Hi,

it can occur when a program that has an associated MMC snap-in, is removed and leaves an orphaned entry in the registry.

do the following:

1. Ignore the message in the Symptoms section and click OK to start MMC.
2. Click Console.
3. Click Add\Remove Snap-in.
4. Click the orphaned snap-in. (The snap-in should not have an icon.)
5. Click Remove.
6. Click OK to close the Add\Remove snap-in window.
7. Save your changes to the console.

its me monty

rpc86
Posting Yak Master

200 Posts

Posted - 2006-12-13 : 00:00:45

monty, thanks.

I did the instructions number 1. What I see from my Enterprise Manager is a folder "CONSOLE ROOT" with a child "Microsoft SQL server". How to activate the Add\Remove Snap-In. I afraid there is no such command or menu for this.

Please help.

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-12-13 : 13:58:55

rpc86,

You need to do the steps Monty listed from the Microsoft Management Console (MMC), not from Enterprise Manager.

Ken

rpc86
Posting Yak Master

200 Posts

Posted - 2006-12-13 : 19:08:34

"Click the orphaned snap-in." Where is orphaned snap-in located? I'm using SQL Server 2000

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-12-14 : 14:01:15

Ummm... In the window you see when you click "Add\Remove Snap-in"? As Monty said: