Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service

Login failed for user ‘cluster service account’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

first thing you might think would be check the account password and see if its working– yeah its working now what next.

Read the error log carefully and try to understand what is happening. here you could see sql server is started but when it tried to attach – make available to cluster with cluster service account it’s getting failed. means the given service account might not have privilege to sql server.

So what we should do, we should make cluster/sql fool and do a work around as failed over the cluster and as soon as sql server started, we open the sql server and checked is the given service account has access to it, and we were right, that account were not existed on to sql server, we have added that account and granted sysadmin role and you know what…. it WORKS !!!

The possibility of this issue could be:

“The cluster service account has been changed and that has not been updated at sql level”

 

This entry was posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s