Single Connection string control multiple database connection on case condtion

[Farrukh hameed]

HI Experts !
I am not sure right area to put my question sorry !

I have multiple databases on different servers , the issue I am facing a downtime if principal server goes down the application cannot able to connect to mirror server ( when failover happens auto & mirror server comes to principal, synchronized ). Is there is a way the below two connection works on condition. suppose if the Main principal server database online then connect to that database else look for other connection string to connect other database(DB2).

<application id="Virtual_Machine">
<description>Virtual_Machine</description>
<database>
<driver>SQLSERVER</driver>
<sqlsyntax>SQLSERVER</sqlsyntax>
<connectString>Data Source=Computername1;Initial Catalog=DB1;User ID=sa;Password=*****;Application Name=testapp</connectString>
</database>
</application>

<application id="Virtual_Machine1">
<description>Virtual_Machine1</description>
<database>
<driver>SQLSERVER</driver>
<sqlsyntax>SQLSERVER</sqlsyntax>
<connectString>Data Source=Computername2;Initial Catalog=DB2;User ID=sa;Password=*****;Application Name=testapp</connectString>
</database>
</application>

 

[fredericofonseca]

if it is a failover cluster then you should be connecting to the cluster SQL name, not the individual nodes
if it is a AG setup then you should be connecting to the AG listener, not the individual nodes.

And in both cases the DB name would be the same, not db1 and db2 as you mention above - or is it that you have replication active to a different db name? that is not ideal and for those you do indeed need to change connection strings.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886