Solved

SQL 2008 MSSQL Service won't start

Posted on 2014-04-23
4
222 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
[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
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

695 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