There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Cannot connect to SQL Azure with Migration Wizard.
I am trying to migrate a Microsoft Access 2010 database to SQL Azure, and am getting the following error from the wizard:
"Connection to SQL Azure Failed. A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible..."
I am able to connect with SQL Management Studio fine, and also tested connecting in Excel, as well as directly with Access 2010 using a Machine DSN, so I believe the firewall settings and credentials are all fine.