Hi Keith,

Before i got your email, I try to remove some register key of SQL server. It lets the situation more mess now. I can't restart SQL server and uninstall SQL server.

Appreciate your any help,

Thanks,

Cathy

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!

Connect with the sa SQL Server account.

--
Keith
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

there is a tip in the SQL magazine about this stuff..
it talks you to go in the registry and change the Security model....this is
when youo lose the password or something, however, the Built/in are just NT
accounts you still have the SA....
check your connection properties..right click on the server name and chose
EDIT REGISTRATION PROPERTIES click on the SQL AUTHENTIDICATION
enter sa and the password...if you go in then just add youor NT admin
account to SQL...

Hi

did u back up the ergistry key before deleting it ??

Hi,

Thanks so much for you guys suggestion. Actually, I removed the system registeration key of MSSQLSERVER using regedit.
So when I start the SQLServer, the following message will pop up as:" MMC: Snap-in failed to initialize". So I can't do anything you talk to me.I guess the SQLserver system is totally dead.And even I can't uninstall and remove the SQLserver because I have no administrator privilege. Right now, the last thing I can do is how to remove the SQLserver clearly from the machine.

Many Thanks and Appreciate Your Any Help,

Cathy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Tony,

How to back up the registry key from SQL Server.

Thanks,

Cathy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Cathy.

Hopefully you realize that you made a couple bad choices that have brought you to your problem now.  Next time don't just go deleting registry entries without being certain of what your problems could be.  Investigate using Books Online and the available support options of online technet (www.microsoft.com/technet).

Right now you have an inoperable SQL Server install.  If you need the data contained in the server you should first make a file backup of everything in the DATA directory of the SQL Server install.

Then if you have a backup of your registry, you can load the key back in.  If you don't have a backup, your best bet would be to start over and reinstall SQL Server.  As long as you have backups of your data directory, you will be able to re-attach that data to your re-installed SQL Server.  

If reinstallation is not an option for you, then you may need to call Microsoft Product Support and see if they can help you rebuild your registry key.

Hi,

I think that there are a utility that allows you to recover the mssql
registry key, the name is regrebld.exe and it is located under the
mssql7/binn directory.

Good luck,

                    Juan

Cathy.

Hopefully you realize that you made a couple bad choices that have brought
you to your problem now.  Next time don't just go deleting registry entries
without being certain of what your problems could be.  Investigate using
Books Online and the available support options of online technet
(www.microsoft.com/technet).

Right now you have an inoperable SQL Server install.  If you need the data
contained in the server you should first make a file backup of everything in
the DATA directory of the SQL Server install.

Then if you have a backup of your registry, you can load the key back in.
If you don't have a backup, your best bet would be to start over and
reinstall SQL Server.  As long as you have backups of your data directory,
you will be able to re-attach that data to your re-installed SQL Server.

If reinstallation is not an option for you, then you may need to call
Microsoft Product Support and see if they can help you rebuild your registry
key.