SQL Server Performance Forum – Threads Archive
SQL ClusteringHi 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
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.
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