June 2, 2009 at 1:08 pm
We are setting up SQL2005 to use Mirroring for failover protection, the application uses a system DSN to connect to the DB. It is setup to use the SQL Native Client with the Mirror server property. Everything works fine when we click the Failover button on the principle server the problem is if the principle server goes down unexpectable ie. I do shut it down and then try and use the application I get an error saying it cannot connect to the server even though the mirror server is now the principle server.
June 5, 2009 at 9:40 am
Are you using a Witness?
do you have the fail-over partner defined the conneciton string of the application?
June 18, 2009 at 1:07 am
Are you still having problems ?
When a failover occurs, your application will get an error because the connection to the database is no longer valid. However, you should then be able to attempt to establish another connection and you should succeed. Any transaction that was in progress when the failover occurred will be rolled back so your application will need to deal with this.
June 18, 2009 at 1:12 am
also, post failover, try hitting few test queries on the server. If u're able to do that, ur application will be able to do so.
Check connectivity parameters in ur application just to be sure.
June 22, 2009 at 9:36 am
I added tcp:servername to my connection strings which solved my problems
June 22, 2009 at 9:38 am
Thanks for sharing the solution 🙂
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply