Solved

SQL 2008 failed to start

Posted on 2011-03-11
4
443 Views
Last Modified: 2012-05-11
I had a similar problem appear as the one discribed in this question:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_26214237.html?sfQueryTermInfo=1+10+30+failur+logon+sql

This error started occuring after I added a second Server 2008 to our first Server 2003 as a DNS and AD server to our network. I receive the exact same error where the password is incorrect and the logon fails. I have tried to follow the instructions to add the administrator user to the "log on as a service" but the "add user or group" is grayed out.

Any ideas why?
0
Comment
Question by:hector-martinez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35114239
Maybe instead of saying "I had a similar problem appear as the one discribed in this question" and "This error started occuring after I added a second Server...." you could provide the actual error that you are receiving.
0
 

Author Comment

by:hector-martinez
ID: 35117286
The error is the exact same on as the referenced question and that would be this:

"The MSSQLSERVER service was unable to log on as bbdomain\administrator with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
 
Service: MSSQLSERVER
Domain and account: bbdomain\administrator
 
This service account does not have the required 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, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right."

When I go to the "Local Security Policies" I can see that the administrator account is not there but the button to add the account is unselectable.
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 35118237
Have you gone through SQL Server Configuration manager to setup the login, or did you set it up directly through services.  I'm guessing the latter.  There are local windows groups which have accounts added to them properly when using the configuration manager that allow the services to start correctly.  Rather than trying to put the right accounts in the right groups, I recommend configuring services through the config tool that SQL Server provides.
0
 

Author Closing Comment

by:hector-martinez
ID: 35232005
I was able to start the service with the local permissions as suggested.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question