Solved

SQL 2008 MSSQL Service won't start

Posted on 2014-04-23
4
204 Views
Last Modified: 2014-04-30
I am getting the following message (see attached picture) on my SQL cluster after changing the service account password.  I have also attempted to change the password back with out success.  I have removed the service account from the admin group and re-added it.
SQL.png
0
Comment
Question by:dorlovitz
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 300 total points
ID: 40019434
On which node are you trying to start the service? If it's a clustered SQL Server only the active node can see and have access to the shared storage and therefore you can start the service only on the active node. If the service is stopped on all nodes, then check the cluster health state. Mae sure the Windows cluster service is up and running and you're on the active node. Check to see if you can see the SQL Server disks (if more than one, all of them).
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 200 total points
ID: 40019531
Also make sure you have changed the service password on both (or all) cluster nodes, and that you are trying to start the service through the cluster manager rather than the MMC snap-in.
0
 

Author Closing Comment

by:dorlovitz
ID: 40032942
It was a combination of these two things.  the nodes both tried to grab the resources and hung them out to dry.  going though the cluster manager and forcing one to stay down and the other to come up resolved the situation
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40033471
Glad you got your cluster up and running.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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