Re: 'Online Pending' status in cluster

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/29/04


Date: Mon, 29 Mar 2004 10:16:13 -0500

Is there anything in any of the event logs, specifically the application and
the system logs?

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rachael" <rachael_faber@hotmail.com> wrote in message
news:OZ25H9ZFEHA.3548@TK2MSFTNGP10.phx.gbl...
> 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: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... This has nothing to do with SQL Server and this is an expected behaviour of Windows Vista operating systems. ... Cause of those popups and normal-user-like acting is some new security system called User Account Control. ... It all seems to be related to security things, even though I am an administrator. ...
    (microsoft.public.sqlserver.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)
  • Re: Permission question - another one
    ... SQL Server looks at when you try to connect using Windows Authentication. ... >>> Does your Windows Login TRAVAC/tfs belong to the local Administrators ... >> Are you talking about on Raptor? ... > I am assuming local administrator is in local users and groups from ...
    (microsoft.public.sqlserver.programming)