I have a connection string as below:
DRIVER=SQL NATIVE CLIENT;SERVER=TCP:NYAVDEVINTDCDB1,5550;
FAILOVER_PARTNER=TCP:NYAVDEVINTDCDB2,5550;DATABASE=DMINTDC;
TRUSTED_CONNECTION=YES;POOLING=TRUE;
Do SQL Native Clients using this connection String have to perform a reconnect when the NYAVDEVINTDCDB1
server gets completely disconnected or loses connectivity from the network? If not, why do I get a
[SQL Native Client]Communication link failure
when this situation arises?
I am using SQL Server Standard Edition 9.00.3152.00 SP2
Clients need to reconnect in the event of a failover.