SQL Mirror - Client auto reconnect in case off mirror live

anvar

Hello,

I'm looking for a way that clients (NAV5 SP1) automaticly reconnect in case off that the mirror goes live.

Explanation:
dbserver : principal
dbmirror : restore db
witness

No connection to the dbserver, so the witness brings the db on the dbmirror live.
Now the problem is that the clients still are connected to the dbserver db, their Nav only gives an OBCD error that there is no connection.
The clients don't know that the mirror is live now.
Is there a way to automate this, so there are full failover capabilities.

Thanks for the replies
Regards

ara3n

No there is no automatic way. The user just needs to be trained to reconnect.

anvar

thanks for the reply, but how can users know that the failover has changed the live dbserver.
They only get a obdc fault...