Last post Apr 23, 2018 04:03 PM by Anand Akula
Apr 12, 2018 08:34 AM|khalid_kuw___|LINK
We had develop ASP.net application with SQL server 2016. Now we upgrade for SQL server to
Always on High Availability
we had now 3 server 1) Witness 2) SQL-Cluster-1 3 ) SQL-cluster-2
in 2016 SQL server we used to have Connection string
Public ConnStr As String = "server=192.168.2.149;Database=EMPLS;UID=FNG_ADMIN;PWD=XXXXX;Connect Timeout=0; pooling='true'; Max Pool Size=400"
Now i want New connection string Which server i had connect ?
Apr 23, 2018 04:03 PM|Anand Akula|LINK
I am not sure if I understood your question. Are you saying that you have moved your server to cluster and which connection string you should be using ? If so, then your connection string will be the same. I think it is setting that should take care which
server to hit based on the availability. when you have a cluster.