Post reply

How does application connect to sql cluster

  • July 29, 2009 at 2:16 pm

    #132335

    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?

  • July 29, 2009 at 3:04 pm

    #1032034

    Yes, you use the virtual SQL servername\instance (and port if you specified it) to connect to the SQL instance.

    When the instance fails over to a different node in the cluster, the instance virtual IP address is moved to the new server.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • July 29, 2009 at 3:44 pm

    #1032051

    Thanks for the quick answer Eddie.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply