Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mneuen
Starting Member
1 Post |
 Posted - 2009-07-29 : 16:22:53
|
| When connecting to a sql server cluster do I use the virtual sqlservername\instancename in the connection string or do you use the windows cluster name? Seems odd you'd have to connect to an instance name. If that instance goes down does it's IP address get moved to a different node's resource? |
|
|
wshawnmelton
Starting Member
17 Posts |
Posted - 2009-07-30 : 15:01:33
|
| If it is not the default instance then you use the Cluster virtual IP or hostname and then reference the instance name. You can reference the individual nodes but it would defeat the purpose of the cluster failover.Example: Custer name is Cluster1 (node names of server1 and server2) with a instance named instance1. Referenced by: Cluster1\instance1w s melton |
 |
|
|
|
|
|
How application connects to sql cluster