Failover problems on 2 active/active SQK 2k clusters on Windows 2003

Greetings

I recently deployed 2 new SQL clusters for our web environments.

We have a legacy cluster that runs windows 2000 server and has active/active
clustering with 2 instances of SQL Server. It works well and has worked well
for years, but we started to outgrow the hardware, so we acquired hardware
and software to build 2 clusters to replace the original.

Our new clusters are having a strange problem though.

In both cases, we have active/active clustering with 2 instances of SQL. The
first cluster has instance names DBSERVER1 and DBSERVER2\DBSERVER2, and the
second cluster has instance names DBSERVER3 and DBSERVER4\DBSERVER4.

The default named instances (DBSERVER1 and DBSERVER3) work just fine on both
clusters on either Win2k3 node, fail over and work seamlessly. However, the
named instances (DBSERVER2\DBSERVER2 and DBSERVER4\DBSERVER4) have odd
problems when they fail over. SQL Server starts up perfectly on the node, I
can use enterprise manager to browse through the tables, etc, but the web
apps give an error - 'SQL Server does not exist or access denied'.

Any ideas? I've wondered if this might have something to do with aliases,
but am not certain. My experience with SQL is somewhat limited and I
followed advice from several books when I deployed these clusters - but it's
possible something was omitted in the procedure that was important.

Thanks!

--john





.

Relevant Pages

  • Re: Using SQL Server Database mirroring between Primary and DR clu
    ... I'm curious how it works out for others as a SQL Server DR tool. ... can replicate any database files. ... The clusters will be configured as active/passive and I would like to ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using SQL Server Database mirroring between Primary and DR clu
    ... can replicate any database files. ... Principal SQL Infrastructure Consultant ... This works just like mirroring does without the witness server. ... The clusters will be configured as active/passive and I would like to ...
    (microsoft.public.sqlserver.clustering)
  • Re: Failover problems on 2 active/active SQK 2k clusters on Windows 2003
    ... I think you are on to something, Geoff. ... Run it against both of our new clusters, and it only finds *1* of the 4 SQL ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering for Performance
    ... SQL 2005 has lots of performance enhancements among other things. ... > Clusters), but the improvements over 2000 seem to be mostly for failover ... >> database since it resides on only one disk resource. ... >>> for failover and not for performance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Failover problems on 2 active/active SQK 2k clusters on Windows 2003
    ... Any suggestions on how I would troubleshoot the SQL Browser? ... Microsoft SQL Server MVP ... I recently deployed 2 new SQL clusters for our web environments. ... The first cluster has instance names DBSERVER1 and DBSERVER2\DBSERVER2, ...
    (microsoft.public.sqlserver.clustering)
Loading