Bug: Bacpac file cannot be imported to Basic/Standard tiers
Bacpac file can be imported only to Web/Business tiers of SQL Azure.
When trying to do this to Basic/Standard tiers the following errora appears:
BadRequest <html version="-//W3C//DTD XHTML 2.0//EN" xml:lang="en" xsi:schemaLocation="http://www.w3.org/1999/xhtml http://www.w3.org/MarkUp/SCHEMA/xhtml2.xsd" xmlns="http://www.w3.org/1999/xhtml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><HEAD><TITLE>Request Error</TITLE></HEAD><BODY><DIV id="content"><P class="heading1"><B>Error Status Code:</B> 'BadRequest'</P><P><B>Details: </B>Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unable to authenticate request; </P></DIV></BODY></html>
Thanks for your feedback, and I’m sorry your having problems importing a Bacpac file. Can you please verify your username/password match between the source DB and the Azure SQL Database that you’re trying to import into. These should be the same SQL credentials that you would use in SSMS, APIs to connect to the Azure SQL Database.
Send me email at firstname.lastname@example.org with you subscription GUID, logical servername, DB name, and how the import/export request was generated (portal? manage.windowsazure.com?, API).
Leila Lali commented
Thanks for your feedback. One of the reasons that can cause authentication failure in the Import/Export service is the database is deactivated. Usually in this case retrying the connection will make the database to activate. The problem here can be that the IE service is not retrying or not waiting enough for database to be activated again. We're going to add the fix in the next release but for now you can try having some retrying logic in the client if the service request fails. Hope that helps.
I had the same issue, it turned out to be the default shown username was not the full database username.