• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

SQL 2008 MSSQL Service won't start

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
dorlovitz
Asked:
dorlovitz
  • 2
2 Solutions
 
ProjectChampionCommented:
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
 
Carl TawnSystems and Integration DeveloperCommented:
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
 
dorlovitzAuthor Commented:
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
 
ProjectChampionCommented:
Glad you got your cluster up and running.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now