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
Solved

SQL 2008 MSSQL Service won't start

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

Suggested Solutions

Title # Comments Views Activity
Replace Dates in query 14 51
SQL BULK INSERT Comma Delimited Issue 8 74
migrate a SQL 2008 to 2016, 2 33
Query Syntax 17 41
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

791 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