Emergy ! 
Author Message
 Emergy !
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!



Tue, 09 Dec 2003 05:20:20 GMT
 Emergy !

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.


Quote:
> When changing the login security, I have a mistake to
> remove the BuildIn/Administrator. I can't change anything
> on SQL server since then. When I try to uninstall and
> reinstall SQL server, a message like "You must have
> administrator priviledges" pops up.

> I would really appreciate your any help,

> Thanks,

> Cathy



Tue, 09 Dec 2003 05:07:57 GMT
 Emergy !
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...


Quote:
> When changing the login security, I have a mistake to
> remove the BuildIn/Administrator. I can't change anything
> on SQL server since then. When I try to uninstall and
> reinstall SQL server, a message like "You must have
> administrator priviledges" pops up.

> I would really appreciate your any help,

> Thanks,

> Cathy



Tue, 09 Dec 2003 10:16:32 GMT
 Emergy !
Hi

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


Quote:
> When changing the login security, I have a mistake to
> remove the BuildIn/Administrator. I can't change anything
> on SQL server since then. When I try to uninstall and
> reinstall SQL server, a message like "You must have
> administrator priviledges" pops up.

> I would really appreciate your any help,

> Thanks,

> Cathy



Tue, 09 Dec 2003 20:21:42 GMT
 Emergy !
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!



Tue, 09 Dec 2003 21:32:27 GMT
 Emergy !
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!



Tue, 09 Dec 2003 22:06:06 GMT
 Emergy !
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.

Quote:

> When changing the login security, I have a mistake to
> remove the BuildIn/Administrator. I can't change anything
> on SQL server since then. When I try to uninstall and
> reinstall SQL server, a message like "You must have
> administrator priviledges" pops up.

> I would really appreciate your any help,

> Thanks,

> Cathy



Tue, 09 Dec 2003 22:39:50 GMT
 Emergy !
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.


Quote:
> When changing the login security, I have a mistake to
> remove the BuildIn/Administrator. I can't change anything
> on SQL server since then. When I try to uninstall and
> reinstall SQL server, a message like "You must have
> administrator priviledges" pops up.

> I would really appreciate your any help,

> Thanks,

> Cathy



Wed, 10 Dec 2003 03:40:47 GMT
 
 [ 8 post ] 

 Relevant Pages 

 
Powered by phpBB® Forum Software