question

JasonBlake-9164 avatar image
0 Votes"
JasonBlake-9164 asked SimonRedman-7820 answered

EXPORT DATABASE Error: 40532

EXPORT DATABASE
An unexpected error was returned by the SQL engine while preparing the operation inputs. Error: 40532, State: 1.

azure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jason,

Is this an Azure SQL Database or Azure SQL Database for MySQL?

0 Votes 0 ·
AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered SimonRedman-7820 commented

Usually that error means: "Cannot open server X requested by the login. The login failed.".

Please make sure you provided appropriate credentials. Use the Server Admin credentials of the Azure SQL logical server to export the database. Use Azure web portal to export the database.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am seeing same error "EXPORT DATABASE Error: 40532" while trying to export azure database to an storage account using portal. It is stuck at 1%. I can see the .bacpac file created in storage container of size 4 Bytes so it means it is able to login to server. Any help would be appreciated. -TIA







0 Votes 0 ·
SimonRedman-7820 avatar image SimonRedman-7820 MahanteshDesai-2556 ·

When the service starts, it writes 4 bytes to the storage URI you specify using the credentials you give it. This is to verify that you have given valid credentials. If you give a SAS token with delete permissions or a Storage Access Key, it will delete the file after verifying.

0 Votes 0 ·
JasonBlake-9164 avatar image
0 Votes"
JasonBlake-9164 answered

Hi @AlbertoMorillo this it the error I get when clicking "Export" in Azure under the database Overview.
I have a premium account and have the ability to store to my Azure storage but I get this error EXPORT DATABASE Error: 40532.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JasonBlake-9164 avatar image
0 Votes"
JasonBlake-9164 answered JasonBlake-9164 published

When I go into Microsoft SQL Management Studio and try to export data I get:
No connection could be made because the target machine actively refused it 10.1.10.25:3306 (System)

===================================

===================================

Unable to connect to any of the specified MySQL hosts. (MySql.Data)


Program Location:

at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)

===================================

One or more errors occurred. (mscorlib)


Program Location:

at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings)
at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.NativeDriver.Open()

===================================

No connection could be made because the target machine actively refused it 10.1.10.25:3306 (System)


Program Location:

at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult)
at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JasonBlake-9164 avatar image
0 Votes"
JasonBlake-9164 answered

In Azure its just stuck at 1% till it fails and give me an error.
I don't understand why I cannot contact Azure support if there is an issue with their software?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MahanteshDesai-2556 avatar image
0 Votes"
MahanteshDesai-2556 answered

I am seeing same error "EXPORT DATABASE Error: 40532" while trying to export azure database to an storage account using portal. It is stuck at 1%. I can see the .bacpac file created in storage container of size 4 Bytes. Any help would be appreciated.

-TIA

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JasonBlake-9164 avatar image
0 Votes"
JasonBlake-9164 answered

It ended up I was putting in the wrong username and password, I had thought it was asking for a NEW password and username but it wasn't the current for that specific database.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SimonRedman-7820 avatar image
0 Votes"
SimonRedman-7820 answered

In one recent case where I saw this, the cause was that the user was trying to use ADPassword but forgot to specify the ADPassword parameter. So they passed their username as "user@example.com". Since ADPassword was not specified, the service assumed SQL login. In a SQL login, the @ specifies to log into a linked server, so it tried to log into "example.com". Since there is no SQL Server running at that address, it throws 40532 (which has message "Cannot open server "{0}" requested by the login. The login failed.")

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.