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

SQL server cluster failed

Error: 5845, Severity: 16, State: 1 in error log  error occured while attempting to bring the resource SQL server MSSQL02

This has 2 node

SQL server MSSQL 01 is online
SQL servver MSSQL 02 is failed
0
dharnet
Asked:
dharnet
  • 4
  • 3
4 Solutions
 
arnoldCommented:
http://www.sqlservercentral.com/Forums/Topic489492-146-1.aspx#bm489673

Double check that the service account (logon account) under/with which the sql server service runs must have the lock pages in memory rights.  Presumably the AD domain account is a restricted user.
GPO computer configuration\windows settings\security settings\rights assignment\
lock pages in memory need to have administrators, and sqlserviceaccount.
http://msdn.microsoft.com/en-us/library/ms190730.aspx
Make sure also add this account in the allow logon as service right.
0
 
Ryan McCauleyData and Analytics ManagerCommented:
You need to include some more details - does one instance fail an the other one works, or do they both fail when they're on one node, but both work on the other node? Also, have they ever worked and these failures are new, or has it never worked and you need helping getting it set up properly?
0
 
dharnetAuthor Commented:
Service account has logon as service right still there is an issue on another node SQL failure. Please suggest
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
arnoldCommented:
Do you use AWE this requires the lock pages in memory right for the same account.

It is not clear from your post what is leading to the failure.  Is the heartbeat network connection present?
Double check that the status of the other node is not merely a designation made in the cluster administrator interface.
What event log entries exist on the failed node dealing with the issue?
0
 
dharnetAuthor Commented:
Event Log on failed node

The Cluster service failed to bring clustered service or application node completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application. 1205 event ID

Cluster resource 'New SQL Server Agent' in clustered service or application node' failed. 1069

I've checked the Lock pages memory permission all are set log on locally right is ok with SA account.
0
 
arnoldCommented:
Are you running an active/active or an active/passive setup?
0
 
arnoldCommented:
If you have two instances, you might not have enough memory to go around i.e. you defined the SQL to use 65% of available memory on each instance and when it fails over to the same node, there is not enough memory for both instances.
0
 
dharnetAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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