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