December 7, 2005 at 1:50 am
I use EM to change service account from local system account to local user account,log on success,but SQL server can't be restarted.Anyboy know why?
December 8, 2005 at 3:06 am
First thing to make sure is that the service Account you are using should have admin privileges.
Try doing the below:
Go to Services in Control Panel -> Administrative Tools and search for MSSQLServer service. Edit the properties and change Startup type to Automatic. Provide Service account under Log On as tab.
Similarly change the properties of SQLServerAgent service.
Next go eo SQL Enterprise Manager under Management you find SQL Server Agent. Right click it and go to properties. In Advanced tab check that first two checkboxes (for automatic starting of SQL Server and Agent) are checked.
Hope this helps.
Anurag
December 8, 2005 at 9:33 am
When you change the account in EM it suppose to do all necesary things to get the account to work with the service but make shure all the properties are set correctly, search for sql service account requirements in microsoft support, like for example this account should have the "logon as a service" property in the local security policy screen, there's a document with a complete description of what's required.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply