Mirroring: Client-side redirect problem

[Guest]

If I unplug my primary server from the network, the client side redirect
fails to work.
I have the connection string “Data Source=primaryserver;Failover
Partner=backupserver;….â€. If the data source machine is not present on the
network I get the error “An error occurred while establishing a connection to
the server. When connecting to SQL Server 2005….â€. It seems to work fine as
long as the machine is connected to the network (e.g. if the SQL Server
service is shut down and I have failed over onto the backup server).

Any ideas?

 

[Guest]

Do you have database mirroring configured properly on both the principal and
failover servers? This may be a good read for errors in a mirroring
environment:

http://msdn2.microsoft.com/en-us/library/ms190913.aspx


-Nate

 

[Guest]

Hi Nate
Many thanks for the reply.
As far as I can see, I have everything setup correctly. The redirect
actually works as long as the primary server is still connected to the
network. The problem only occurs when I physically unplug the primary machine
from the network.

Regards
Will