Solved

SQL 2008 MSSQL Service won't start

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

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 …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now