Need to Auto-start SQL Server Service when OS Starts

[Jay Bollyn]

Running SQL Server 2k on Windows Server 2k3 in our DMZ.

I am new to both the OS and SQL administration. I installed SQL from the built-in Administrator account. Some time later, I renamed the Administrator account for security reasons. But then, the SQL Server Service could not auto-start when the OS starts. I don't remember the exact error msg, but SQL was trying to authenticate with (Administrator/passwd), which failed because it was now (RenamedAdminAcct/passwd). I renamed the built-in account back to Administrator, so SQL does auto-start again.

If someone could tell me how to tell SQL to authenticate with (RenamedAdminAcct/passwd), I would really appreciate it. (Short of reinstalling SQL.)

Of course, points assigned.

:-) Jay

[Roger Faucher · Accepted solution]

Jay:

Go to Administrative Tools/Services and find SQL Server Service. Double-click it and select the Log On tab, then set the username and password to match what you desire(RenamedAdminAcct/passwd, for instance).

Make a great day!

Roger

I don't have WIN2K3 running so the procedures may differ. I'm using WIN2K.

[Jim Mallett]

There may be a second service that you need to change the information in, on my system there is:
MSSQLSERVER
SQLSERVERAGENT

Both of them rely on Administrator rather than just LocalSystem. As Roger said, go into Services and you can make changes in "Properties".

While you're in there, it may be a good time to scan down through all your services and see if anything else is dependend on Administrator information, most should be LocalSystem though.

Jim

[Jay Bollyn]

Thanks both, it is working. I need to clean my glasses more often.

:-) Jay