Database mirroring failure

Hello everyone

I am using "FAILOVER PARTNER" IN sqlconnection string for data mirroring in my asp.net application. but it didn't work.

following is my code snippest.

<div>namespace DBFailoverTest
{
class Program
{
static void Main(string[] args)
{
string connectionString = "Data Source=server1;Failover Partner=server2;Initial Catalog=testdb;Persist Security Info=True;User ID=user;password=letmein";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand queryCommand = new SqlCommand("SELECT 1", connection);
SqlDataReader queryCommandReader = queryCommand.ExecuteReader();
}
}
}
}

When I am tring to connect server1 Which is failure it can't switch to Server2.

Can you please tell where i am wrong? or Any other method that will helpful to me

Thanks in advance.

Re: Database mirroring failure

http://www.connectionstrings.com/sql-server-2005

http://stackoverflow.com/questions/677678/how-to-add-failover-partner-to-a-connection-string-in-vb-net

http://blogs.msdn.com/b/spike/archive/2010/12/08/clarification-on-the-failover-partner-in-the-connectionstring-in-database-mirror-setup.aspx

http://www.sqlservercentral.com/blogs/hugo/2010/10/06/connection-stings-database-mirroring-failover-partner-setup-amp-sample-backup-restore-preparation-script/

Will Help you

Re: Database mirroring failure

Hi,

Have you tried use Network in your connection string? If not, please try it in your application.

Example: "Server=Partner_A; Failover_Partner=Partner_B; Database=AdventureWorks; Network=dbmssocn"

You could follow below article to Configure the ASP.NET Application to Use the Mirrored Database.

http://www.codeproject.com/Articles/31325/Step-by-Step-SQL-Mirroring-the-ASPState-Database

More information about Making the Initial Connection to a Database Mirroring Session : http://technet.microsoft.com/en-us/library/ms175484.aspx

Thanks.