I recently upgraded my SQL Server 2000 to SP4. Unfortunately, upon completing the installation my SQL Server has been rendered useless. Whenever I would open Enterprise Manager, it would splash the error "MMC could not create the snap-in". I tried to manually add the snap-in as others had suggested in other questions, however it would give me an error when I would attempt to do so. So I uninstalled SQL Server and reinstalled. However, it did no good, except change the error symptoms. Now when I go into Enterprise Manager, I get the error "Microsoft SQL-DMO - Error 65535: General Error" and then if I try to add a new sql server registration, it gives me the error "Server registration information cannot be changed on remote Registries". Now, I cannot even uninstall, for if I try, it complains that "The log file 'C:\Program Files\Microsoft SQL Server\80\Tools\Uninst.isu' is not valid or the data has been corrupted. Uninstallation will not continue."

Thanks in advance for any help with reviving my system.

Try installing again as a named instance.
You may have to clean the registry and delete the files. There are third party products which clean the rgistry. Keep a backup of the registry first.
Actually for the problem you faced first, si something common. But to resolve that issue, Dont even jump in for a reinstallation. Re-installation should always the last thing you should do.


G.R.Preethiviraj Kulasingham

Thanks for the reply, Preethi.

Unfortunately, even installing again as a named instance does no good. This is rather frustrating, considering that I am trying to use this machine for development.

Are you by any chance addressing the machine as localhost?

If so, try (local) or . instead....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

I'm not sure what you mean. I'm simply trying to connect to SQL Server through Enterprise Manager.

If you try to make a connection, you need to provide a name for the server to connect to. There you need to provide (local) instead of localhost.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

I think you misunderstand. I understand how to connect to SQL Server. The issue is that Enterprise Manager is not functioning. I don't even get to a place where I would be able to enter connection information to register my server.

I am afraid the only option (Other than format & re-install all) is the remove all the files in the SQL folder and remove the registry entries too.
(This is where you need to use a third party registry cleaner)

Just before that please have a look into this. Some people faced the MMC issue and resolved in different way. I remember you too faced the same problem initially.

http://support.microsoft.com/kb/914157




G.R.Preethiviraj Kulasingham

Sorry, yes, I misunderstood. I thought you had trouble connecting to instances of SQL Server.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Thanks for the comments, guys.

Ultimately, it looks like I will be formatting during some off time. Oh well.