sql server service adn agent shows offline in failover cluster manager
-
i have a 2 node active/passive setup for sql server 2008.
in the active node if i go to the cluster manager, i see the sql server service and agent as offline,but they are currently running,none of the clients have reported down issues.
if i go to the passive node, i don't see any thing in cluster manager and if i go to sql server configuration manager, i see 'the server threw exception error'.
interestingly if i use the same account on which the sql server and agent is installed to log in into the passive node, i don't get this exception in configuration manager and i see the items in cluster manager.but still the server and agent is showing offline.
please help..any help is appreciated.
thanks
-
what does the following return when executed against the sql instance
SELECT
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS PhysicalNodeName,
SERVERPROPERTY('ServerName') AS ClusteredInstName,
SERVERPROPERTY('IsClustered') AS IsClustered
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
In addition to what Perry has asked - are the services on each node set to manual startup or automatic?
And - what is the version of the OS you are running?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
good call on the service status' Jeffrey
I'm assuming as the OP mentions "Failover cluster manager" that the OS\cluster is Windows 2008
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Perry Whittle (4/6/2011)
what does the following return when executed against the sql instanceSELECT
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS PhysicalNodeName,
SERVERPROPERTY('ServerName') AS ClusteredInstName,
SERVERPROPERTY('IsClustered') AS IsClustered
result of the above query
PhysicalNodeName ClusteredInstName IsClustered
PHYDB001 DBCLUSTER 1
also the OS its running on is ---windows server 2008 r2 datacenter
the service start up is -- manual
--------------------------------------------
--thanks a lot for the help guys!!
-
the services are running as per the service configuration manager and none of the clients have complained that they are down.
but as per the cluster manager, the services are offline,any help is greatly appreciated..
-
so if i read this correct you're saying that if you check the services list on node ECW10PHYDB001 the services are running but when looking through Failover cluster manager the groups resources\services read as offline?
I just want to check, you sure you opened a connection to the correct cluster??
Can you supply screenshots? Go onto the active node (shown above) and open Failover cluster manager then select the SQL Server group and take a screenshot. Also open the Services.msc console, scroll down to the SQL Server services and screenshot these too
Post these back when you have them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
check the screen shots plz..
-
this problem occurs when SQL Server and agent service is started somewhere else like
Administrative Tools->Services,not from the Cluster Manager
Just right click on a Service and then click on RESOURCE ONLINE and do same with agent job also,it will just update itself nothing else
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBAMy Blog
www.aureus-salah.com
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply