topic Need to Auto-start SQL Server Service when OS Starts in Windows Server 2003

Need to Auto-start SQL Server Service when OS Starts

Jay Bollyn — Sat, 04 Sep 2004 20:11:18 GMT

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

Re: Need to Auto-start SQL Server Service when OS Starts

Roger Faucher — Sun, 05 Sep 2004 01:20:00 GMT

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.

Re: Need to Auto-start SQL Server Service when OS Starts

Jim Mallett — Sun, 05 Sep 2004 01:59:20 GMT

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

Re: Need to Auto-start SQL Server Service when OS Starts

Jay Bollyn — Sun, 05 Sep 2004 06:01:49 GMT

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

:-) Jay