Thursday, February 9, 2012

admin name change does not allow mssql to start up

I installed mssql 2K when the sys admin acount name was adminis1. I used that as the service startup account. Everything worked fine. I had to change the sys admin account name to adminis2. When I rebooted Mssql would not start up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?
Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment