Error 435 bringing resource online?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 10 Mar 2005 06:59 GMT

Hi All,

I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with
SQL Server 2000 SP3a. This is a development system, and is actually
implemented using VMware (though I don't think that is relevant).

Occasionally when moving the SQL Server group, I get random failures of SQL
Server, Agent, or Fulltext. Going through cluster.log, I find entries like
the following:

000002d4.0000020c::2005/03/10-05:56:37.490 ERR SQL Server <SQL Server>:
[sqsrvres] StartResourceService: Failed to start MSSQLSERVER service.
CurrentState: 1
000002d4.0000020c::2005/03/10-05:56:37.490 ERR SQL Server <SQL Server>:
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435)
000002d4.0000020c::2005/03/10-05:56:37.505 ERR SQL Server <SQL Server>:
[sqsrvres] OnlineThread: Error 435 bringing resource online.

and

000002d4.00000cf0::2005/03/10-06:09:52.281 ERR <Unknown Resource>:
[sqsrvres] StartResourceService: Failed to start SQLSERVERAGENT service.
CurrentState: 1
000002d4.00000cf0::2005/03/10-06:09:52.281 ERR SQL Server Agent <SQL Server
Agent>: [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status
435)
000002d4.00000cf0::2005/03/10-06:09:52.281 ERR SQL Server Agent <SQL Server
Agent>: [sqagtres] OnlineThread: Error 435 bringing resource online.

Any ideas as to what is going wrong? Could this be network-related?

Many thanks,
John.

Reply to this Message

Hans de Bruin - 10 Mar 2005 09:11 GMT

> Hi All,
>
> I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with
> SQL Server 2000 SP3a. This is a development system, and is actually
> implemented using VMware (though I don't think that is relevant).

It could be relevant. Workstation 4.x does too much disk caching so disk
corruption will occur, on the quorum disk for example. VMWare GSX 3 is
fine a long as you add disk.locking="FALSE" and scsi0.sharedBus="virtual"

Signature

Hans

Reply to this Message

John - 10 Mar 2005 19:01 GMT

Thanks for the response. Yes, I am using VMware Workstation 4.5 - that may
be an issue.

Is there a way of finding out exactly what error 435 means? It does not
seem to be a standard error code; "net helpmsg" does not help.

Thanks,
John.

> > Hi All,
> >
[quoted text clipped - 5 lines]
> corruption will occur, on the quorum disk for example. VMWare GSX 3 is
> fine a long as you add disk.locking="FALSE" and scsi0.sharedBus="virtual"

Reply to this Message

Hansde Bruin - 11 Mar 2005 18:03 GMT

> Thanks for the response. Yes, I am using VMware Workstation 4.5 - that may
> be an issue.
>
> Is there a way of finding out exactly what error 435 means? It does not
> seem to be a standard error code; "net helpmsg" does not help.

Cluster service can't bring the resources online. Check the windows event
log and the sql log files to find out why. When that does not help, run a
dos box as the sql service account an start sql from the command line (not
net start but the sqlserver.exe).

If you really want to cluster with vmware either use a single node cluster
or use iscsi drives. I have got an out of date site which describes this:
http://eratosthenes.xs4all.nl/wmwarecluster/ .

Signature

Hans

Reply to this Message

AshaR - 16 Apr 2005 22:16 GMT

What was the fix for this? I am having the same exact issue.

> > Thanks for the response. Yes, I am using VMware Workstation 4.5 -
> that may
[quoted text clipped - 20 lines]
> --
> Hans *

--
AshaR

Reply to this Message

q - 09 Jul 2008 15:32 GMT

I'm not quite sure, that it will help, but try this:

In a Windows Server 2003 domain
Open Active Directory Users and Computers.
In the console tree, click Users.
In the details pane, right-click the user you want to run agent under, and
click Properties.
Click the Delegation tab, select the "Account is trusted for delegation"
check box, and then click OK.

after that SQL Agent have started in my case.
Also be sure to check log-file via SQL Server management tool

url:http://www.ureader.com/msg/11426.aspx

Reply to this Message