[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Database Export Error



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Database Export Error.

Applies to: SQL Azure Database V12.

Problem Description.

I was trying to export a SQL Azure database to an Azure BLOB using the GUI on the new Azure portal, when I received the following error message:

Database Export Error
Failed to export the database: AdventureWorksLT.ErrorCode: 400 ErrorMessage: There was an error that occurred during this operation: '<string xmlns="http://schemas.microsoft.com/2003/10/Serialization"> encountered during the service operation.; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException to authenticate request; Inner exception System.Data.SqlClient.SqlException:Cannot open server &amp;#39;morillo&amp;#39; requested by the login. Client with IP address &amp;#39;137.166.48.xx&amp;#39; is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect; </string>


This error appears when the credentials provided for Server Admin Login are not correct. The current login name and password must be provided.




.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.