dbTalk Databases Forums  

Cluster Issue

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


Discuss Cluster Issue in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #61  
Old   
Francisco Parrilla
 
Posts: n/a

Default Re: Cluster Issue - 01-28-2008 , 02:59 PM






Have you cluster in:

- SAN
- Into Active Directory
- The service Cluster start
- All disk resources state online

Give more details ...


"Bob Smith" <BobSmith (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,

I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on
Failover
from node2 to node1 the application user is unable to login until the sql
server is restarted, on failover all the resourses come online but the
user
is unable to access the database and if I look in SQl Server management
studio I am unable to see the properties of the DB, if I initiate a
failure
of SQL server in the cluster I am still unable to access the DB but if I
restart SQL server in management studio the database comes online.

Also when I do a failover to node2, it shows all resourses are online but
the application cannot access the DB like it is not there, but I can
access
the Quorum and the shared DB drive.

Thanks in advance,
Bob Smith



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.