Windows Services

ramziabk
ramziabk used Ask the Experts™
on
I have a issue with SQL 2005 windows service. To start the service, I have to enter the domain user name and password everytime.

So in case I restarted the server, it won't work unless I manully enter the username and password. Note that I've saved the username and password but still not working. Any idea?
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
jbvernejTechnical Support Engineer

Commented:
hello,

on Which operating system ?

Did you change/type service /password with the right tool ?
With SQL Server, it MUST be done via the "SQL Server Configuration Manager" Tool and not via the usual Windows Services MMC console.

Changing the Service Account in SQLServer need some another internal actions (in the registry, probably) that the classic Windows Services MMC cann't do.

Could you try to re-change/re-type service account  and password for this SQL with only the SQL Server Configuration Manager tool ?
(and don't forget to launch this tools with the "Run As Administrator" option )
Senior Systems and Integration Developer
Commented:
You also need to make sure that the account is granted "Log on as a service" permissions at the group policy level, otherwise they will be lost every time the machine restarts - hence you have to enter the details again.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial