Cluster error

Question

Cluster error

zacccc

SSC-Addicted

Points: 401
More actions
September 19, 2008 at 2:20 am

#198302

I have made active / passive cluster sql 2005. When you want to switch all the node2 not rising SQL Server and some services. Occurs to me this log errors.
initerrlog: Could not open error log file 'S:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 3(error not found).
The configuration of the NP protocol in the SQL instance MSSQLSERVER is not valid.
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435)
[sqsrvres] StartResourceService: Failed to start MSSQLSERVER service. CurrentState: 1

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Is S a shared drive? Is it available to Node 2?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zacccc SSC-Addicted Points: 401 More actions · Answer 2

How to verify? Is it a classic share folder or ..?

zacccc SSC-Addicted Points: 401 More actions · Answer 3

zacccc

SSC-Addicted

Points: 401

September 19, 2008 at 2:44 am

#874058

I checked the disk with share marked S $.

Wilfred van Dijk SSCrazy Eights Points: 9003 More actions · Answer 4

Windows Cluster is a shared-nothing concept, which means the database can only be seen from the active cluster. This is probably on your S: drive. After a failover, your S: drive is connected to the other clusternode and the original clusterserver has no longer access to this drive. The whole cluster concept is controlled by a quorum disk, mostly the Q: drive (you're not allowed to use this disk).

In order to have the passive clusternode access to a shared/failover drive, you need to create a new clustergroup with its own drive.

Make sure you know the concepts before implementing this (or ask your windows guys)

Wilfred
The best things in life are the simple things

zacccc SSC-Addicted Points: 401 More actions · Answer 5

I know what the cluster and how to work. I have already made several cluster, but I've never had this problem.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 6

If you log onto node 2 (remote desktop), can you see drive S in windows explorer?

If you open cluster administrator, is drive S a dependency of the SQL group (it should be). What's the state of that resource in cluster admin?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zacccc SSC-Addicted Points: 401 More actions · Answer 7

Everything is in the cluster group. I have only one group. I see the disk S and can enter into it. But I do not see any folder on your hard disk S. Analysis Services has failed, SQL Server has failed and SQL Server Agent is offline. On node1 I can see SQL folder on hard disk S.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 8

Hang on, you can see S drive from both nodes?

If so, that means that different 'drives' are getting mapped as S on the two nodes. You should be able to see S from node 2, but not from node 1 if node 2 is currently active for that group. In a cluster there's no way that both nodes can own a resource at the same time.

Can you double check the resource mappings for the drives?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zacccc SSC-Addicted Points: 401 More actions · Answer 9

Wrongly understood me. I am switched all the resources at node2 and connect with node1 to node2 and looked through the remote desktop ..

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 10

Ok, so if Node 1 is active you can see S drive and it has a whole directory structure, if node 2 is active you can see S drive but it has no directories at all?

Is that consistent? If you fail the cluster back to node 1 now, can you see the S drive intact and does SQL start?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zacccc SSC-Addicted Points: 401 More actions · Answer 11

When is node1 active everything work I can see the disk with SQL folder. When the active node2 I can see disc, but I do not see folder of SQL. On node1 services are working normally. When is active node2 these servisec are offline or failed :SQL Server, SQL Server Agent and Analysis Services