"William Buchanan" wrote:

> 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?
>

"Nate" wrote:

> 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
>
> "William Buchanan" wrote:
>
> > 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?
> >