SQL Server resource failed but SQL starts

#1

We have 2 SQL clusters where the SQL Server cluster resource fails but if you
go to the SQL Manager, you can start the service and query the DB.

Has anyone seen this before?

#2

This could be due to any one of several reasons ranging from long recovery
times to DNS issues to general networking issues. You will need to look
into the SQL Server error logs, the system & application event logs and the
cluster log to get an idea of which area to start drilling into.

John Gose
MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS", with no warranties, and confers no rights

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------

Quote:

Thread-Topic: SQL Server resource failed but SQL starts
thread-index: AcSxQOn50xxQKw6WRgqMVPE1llFc/Q==
X-WBNR-Posting-Host: 65.160.93.12
From: =?Utf-8?B?Um9uaXZhIEJyb3du?= <Roniva
Brown (AT) discussions (DOT) microsoft.com
Subject: SQL Server resource failed but SQL starts
Date: Wed, 13 Oct 2004 09:23:03 -0700
Lines: 4

Snip of Header Stuff

We have 2 SQL clusters where the SQL Server cluster resource fails but if
you
go to the SQL Manager, you can start the service and query the DB.

Has anyone seen this before?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server resource failed but SQL starts

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

SQL Server resource failed but SQL starts - 10-13-2004 , 11:23 AM

RE: SQL Server resource failed but SQL starts - 10-14-2004 , 11:10 AM