Re: Cluster Issue



Have you cluster in:

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

Give more details ...


"Bob Smith" <BobSmith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F586AE13-D88E-4893-A6A3-0465392C13F2@xxxxxxxxxxxxxxxx
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


.



Relevant Pages

  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)