June 22, 2011 at 9:02 am
Everytime I reboot my server the SQL services are not coming up and they are failing with following error.
"error 1069: the sql did not start due to logon failure" . I am keep applying the same password again and again to the SQL services in logon window and starting them....
I am thinking the issue is with Service account which I use to start the SQL service. Is their any way to fix this?
June 22, 2011 at 9:25 am
Try this for a start... it's amazing what you can find with a simple search!
http://support.microsoft.com/kb/259733
John
June 22, 2011 at 10:31 am
Thanks John.
I did check online first and none of the solutions fixed my issue so I thought of checking in this forum.
June 22, 2011 at 11:01 am
Did that article fix things?
Is there a check requiring the change of the password on login?
Clustering involved?
June 22, 2011 at 11:18 am
No and we are on stand alone.
I did the following steps as suggested by Article but did NOT fixed the issue. The service account I am using is a domain account.
Domain Controller
If the user is in an Active Directory domain:
Start the Active Directory Users and Computers Microsoft Management Console (MMC) snap-in.
Right-click the Organizational Unit (OU) in which the user right to log on as a service was granted. By default, this is in the Domain Controllers OU.
Right-click the container, and then click Properties.
On the Group Policy tab, click Default Domain Controllers Policy, and then click Edit. This starts Group Policy Manager.
Expand the Computer Configuration object by clicking the plus sign (+) next to the policy object. Under the Computer Configuration object, expand Windows Settings, and then expand Security Settings.
Expand Local Policies, and then click User Rights Assignment.
In the right pane, right-click Log on as a service, and then click Security.
Add the user to the policy, and then click OK.
Quit Group Policy Manager, close Group Policy properties, and then close the Active Directory Users and Computers MMC snap-in.
June 22, 2011 at 12:19 pm
Can you try this?
- Create a new user in AD, no rights.
- Use SQL Config Manager to assign this user as the service account.
- Restart SQL Server.
June 23, 2011 at 7:37 am
I have used "Log On" tab through sql server cofiguration manager to apply the account but still no luck
June 23, 2011 at 7:39 am
but I am not sure how to assign user as service account in SQL Conf manager.
June 23, 2011 at 8:29 am
In the properties for a services in config manager, the first tab as a Log On As and a "Use this account" with a browse button. You just pick any user account and the tool will assign rights.
June 23, 2011 at 9:32 am
It worked after followig these steps..
This service account does not have the necessary user right "Log on as a service."
User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
If you have already assigned this user right to the service account, and the user right appears to be removed, a Group Policy object associated with this node might be removing the right. Check with your domain administrator to find out if this is happening.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply