'Online Pending' status in cluster

From: Rachael (rachael_faber_at_hotmail.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 07:05:30 -0800

Hello,
I have SQL Server 2k Enterprise Edition, sp3 installed on a cluster.
When SQL Server first installs, everything looks fine in the cluster
administrator. However after about 30 minutes or so the status of
MSSQLServer, SQL Server Agent and SQL Server Full Text services goes
from 'Online' to 'Online Pending'. The service looks to be stopped when
I am in Enterprise Manager but I can still get in and look around the
databases - but only for a short time. After another 30 minutes or so,
the status of the services in the cluster administrator goes from
'Online Pending' to 'Failed' and there's no error messages to give me
any clues. Any help would be wonderful!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Service Accounts on SQL Server, Best Practices
    ... SQL Server and SQL Server Agent service accounts do not need to be a local administrator or domain administrator for Failover Clustering on Windows 2000 ... If the service account for SQL Server is not an administrator in a cluster, the administrative shares cannot be deleted on any nodes of the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error 42d during Fail Over SQL 2000 Enterprise in a Server 2003 Ent. Cluster
    ... a valid login that you add back the service account that operates the ... Cluster service. ... Microsoft SQL Server MVP ... Administrator account, have re-entered the username and password 3+ ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster Taken Offline Accidentally
    ... Can you use RDP to connect to one of the nodes and run Cluster Admin from ... SQL Server MVP ... taken offline and neither node can connect to it, since the IP, name, a Q ... Administrator to turn them back online, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
Loading