SQL Server Performance

SQL Clustering

Discussion in 'SQL Server Clustering' started by support10, May 27, 2005.

  1. support10 New Member

    Hi all,

    Need ur help on this one.

    I had Client Server Application written on VB and VB.NET.

    Both approach of connecting to the SQL Server is by the SQL Server Name follow by the Database Name using the

    SQLOLEDB for ADO and ADO.NET.

    By using the Virtual SQL Name or IP Address, will these application be able to access the SQL Server?

    Secondly, when we create the System DNS Name using OCBC Data Source Administrator, what will we see when we try to create 1 for the SQL Server?
    Is it the Virtual SQL Name or the actual SQL Server Name?

    Hope u guys could help me on this.

    Tks.

    Mohd
  2. Argyle New Member

    You should use the virtual SQL Server name and nothing else. This is the name SQL Server has. Using IP will only work on the default instance, not on named instances.
  3. deepakontheweb New Member


    if you have 2 node A/P cluster

    Node 1 : clusterdb01
    Node 2 : clusterdb02

    Virtual Name : clusterDB

    you can see all three names; but should use only Virtual name because it will connect application/DSN to active server. [else if you specify node names that can go passive/offline anytime]

    Deepak Kumar

    --An eye for an eye and everyone shall be blind

Share This Page