• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

On restarting the server, SQL server service does not start automatically

Although the SQL server service startup type is automatic, the service does not start on restarting the server. If I try to start the service it errors saying  "Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]" I have to go into the properties and log on tab and put in the password.

Once this is done the service starts successfully. Any ideas why the SQL server service cannot retain the credentials.
0
Cromwellhospital
Asked:
Cromwellhospital
1 Solution
 
imran_fastCommented:
change the service startup account to some another user having admin or appropriate privellege.
for the above user check the limitation
http://support.microsoft.com/kb/907557

and here is how to set the sql service account
this is microsoft article
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811
Grant the service account appropriate user rights - with Active Directory based or local group policy, depending on account type. After you launch the Group Policy Editor, containing either local or Active Directory container-specific settings, in the Computer Configuration portion of the policy, drill down to Windows Settings -> Security Settings -> Local Policies -> User Rights Assignment folder. After double-clicking on the relevant (outlined in the KB article Q283811) user rights from the list displayed in the details pane, add the service account name to the group of privileged accounts.
Grant the service account permissions to registry keys outlined in the KB article Q283811- with the help of the Registry Editor.
Grant the service account permissions to folders and their content outlined in the KB article Q283811 (assuming that you followed Microsoft recommendations and installed SQL Server on an NTFS-formatted partition),
You might need to add the service account to the SQL Server 2000 fixed server sysadmin role. You can handle this either with SQL Enterprise Manager (e.g. by launching Create Login Wizard) or with Query Analyzer (by executing sp_grantlogin and sp_addsrvrolemember stored procedures, as demonstrated in the KB article Q283811).
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now