Cannot export database into bacpac file

(0) Share

Report

Posted on by tdgscorpion

107

Hello,

I am tring to export AxDB from sql of Dev on box environment to BACPAC file. I am using SQL Management studio Export data-tire application wizard. But it throws the folloing errors after some time:

Error SQL71627: The element User: [NT AUTHORITY\NETWORK SERVICE] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element Login: [NT AUTHORITY\NETWORK SERVICE] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.

Do you have any idea how to do it. I need to create a BACPAC file.

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report

bacpac only supports Azure database Authentication , which doesn't support Windows Authentication.

Remove User from DB and try to export it again

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Teodor,

You need to prepare the SQL database before you can export it to a bacpac file. Please check the script you will need to run in this documentation.

Was this reply helpful? Yes No