title: Connect timeout, database failover not working
body: <p>I have implemented database mirroring on Azure with a witness, using SQL Server 2008. The mirroring / failover works on the SQL Server side. The problem I am having is that once a failover has occurred my asp.net Website does not connect to the new principle database and is still trying to connect the the old principle. </p>
  
  <p>I have tried adding a 60s Connect Timeout to my connection string as suggested in this <a href="https://serverfault.com/questions/249589/db-auto-failover-in-c-does-not-work-when-the-principal-server-physically-goes-o">post</a>. However this does not have any effect. And all I end up getting is the following error after around 60s:</p>
  
  <blockquote>
    <p>Request timed out.</p>
  </blockquote>
  
  <p>Does anyone have any other suggestions?</p>
  
  <p>Any help much appreciated!</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>My connection string is:</p>
  
  <blockquote>
    <p>data source=server1;Failover Partner=server2;initial catalog=DBNAME;User Id=WebsiteUser; Password=******;Connect Timeout=60;multipleactiveresultsets=True</p>
  </blockquote>