Do SQL Native Client connections need to be reopened after a complete failure of the principal server in a mirrored env?

Question

Hi, I have a connectionstring 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 cxn String have to perform a reconnect when the NYAVDEVINTDCDB1 server gets completely disconnected/ 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

Regards, Hegs

Answer 1

Clients need to reconnect in the event of a failover.