Post reply

Determining where or how a connection is being made to SQL

  • January 23, 2012 at 10:48 am

    #1437240

    kurtwest (1/19/2012)

    I don't think the DNS Alias will work in this case. I am going from two stand alone SQL servers and two clustered SQL servers, to a new cluster. I can just switch the DNS name, because I have to go from SQLA to SQLCuster\Instance1. Correct me if I am wrong.

    Here's the cunning thing. If you get your new SQL instances (in the cluster) to listen on port 1433 you don't have to specify an instance name. You could just connect to SQLCluster without the \Instance1


    Shamless self promotion - read my blog http://sirsql.net

Viewing post 16 (of 16 total)

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