Active/Active Cluster on Windows 2003 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Active/Active Cluster on Windows 2003

We are using Windows 2003 and SQL Server 2000 with the latest service packs. We have created an active/active cluster using named instances and I would like to connect to the sql server instances as InstanceName rather than ServerNameInstanceName from the client connection which do not have sql server installed. Our client machinces are Windows 2000 Server using the latest mdac and .Net 1.1. Any ideas or help on this would be great? Thanks,

In the client network utility on the client machines, just set up an alias. That will work for you. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
I currently don’t have sql server or the client utility installed on the other machines. Is there any other options or should I install the client utility on all the other servers? Thanks,

It turns out the Client Network Utility to configure an alias to SQL Server is automatically installed with MDAC. So, all you have to do is run the utility on every client machine to configure an alias to the clustered named instance. The path to the utility is:
C:WINDOWSsystem32cliconfg.exe Thanks,