title: How to prevent local connection timeout when using SQL Azure Migration Wizard
body: <p>I am trying to export data from my sql server database using the <a href="http://sqlazuremw.codeplex.com/" rel="nofollow">Sql Azure Migration Wizard</a>. I am intermittently hitting a problem with timeouts:    </p>
  
  <blockquote>
    <p>Unable to complete login process due to delay in opening server
    connection</p>
  </blockquote>
  
  <p>Is it possible to increase the timeout used by the migration wizard? Or can I change the default timeout in sql server?</p>
  
  <p>NB I am getting this problem on my own server, not when I try to connect to Azure.</p>
  
  <p><strong>Edit</strong>
  At the bottom of the Result Summary tab the wizard prints a summary of the bcp output commands used to export data. I copied these into a command window and they ran. Still getting timeouts reported. So it appears to be a limitation to do with bcp. I am using Sql Server 2008 R2 and bcp version 10.50.1600.1</p>