Re: SQL Server service stopping mode on One Cluster Node

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Geoff,

Thanks for reply.

Only SQL Server service and Agent gets failed and never comes online until
reboot of the server, other resources status is Online.


Dinesh
"Geoff N. Hiten" wrote:

The application log should show why the SQL instance failed.

It looks like the SQL instance is not responding to the cluster resource
"looksAlive" and "IsAlive" checks. Might be a dependency error. Try and
bring the disk resources online, then the IP , then the network name
resources online. Then try and bring the SQL Server resource online and see
if you get better results or at least better error messages.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Dinesh Bhandare" <Dinesh Bhandare@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:AF06E59C-99C3-4F17-987A-D666FEB9EC08@xxxxxxxxxxxxxxxx
OS= Windows 2003 64Bit Ent. R2 SP2 (latest updates)
SQL Server= MS SQL 64Bit Ent. with SP2
Below events gets generated on Cluster Node :-

1]The Cluster Service failed to bring the Resource Group "ABCD" completely
online or offline.
2]Cluster resource 'SQL Server' in Resource Group 'IABCD' failed. (Event
id
-1069)
3]The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It
has done this 1 time(s). --Event ID -- 7039

Event ID - 19019
[sqsrvres] CheckServiceAlive: Service is dead
[sqsrvres] OnlineThread: Error 1 bringing resource online.
[sqsrvres] OnlineThread: service stopped while waiting for QP.
[sqsrvres] CheckServiceAlive: Service is dead
[sqsrvres] OnlineThread: Error connecting to SQL Server.
[sqsrvres] ConnectToSQL: service stopped while trying to connect to
server.
[sqsrvres] CheckServiceAlive: Service is dead

When we try to bring onlibe the failed resources or move group then server
goes to hung state.

Please help in this .

Thanks in Advance.

Regards
Dinesh Bhandare

.

.

Relevant Pages

  • RE: cluster resource in resource group failed
    ... Keywords: Classic,Audit Failure ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • RE: SQL Server service stopping mode on One Cluster Node
    ... My SQL Server simply will not come online and I don't know why. ... SQL and SQL Agent run under the same domain/service account ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to failover
    ... With clustering, you must not start and stop services from control panel. ... You must use Windows Cluster Manager to take resources offline / online ... Look in Windows Online help for Clustering information. ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2000 Cluster Manual Failover
    ... whole doesn't actually fail over), but some of them come online where ... Physical Disk resources will come online in the second node, ... SQL Server, SQL Server Agent, and Full Text resources won't come online ...
    (microsoft.public.sqlserver.clustering)
  • Re: cluster resource in resource group failed
    ... And make sure that the SQL Service account has "log on as a service" rights. ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)