Unable to ‘Deploy Database to Microsoft Azure SQL Database’ from SSMS 20.2

admin

Hi have attempted to deploy our on-premise SQL Database to an Azure SQLDB using SQL Server Management Studion 20.2

enter image description here

However, I getting the following errors:

Error SQL71627: The element User: [topbs\pina] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element User: [LAP0134-NT\serveradmin] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element User: [CAPWINDS\mY_Team] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element User: [NT AUTHORITY\SYSTEM] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.

Can someone let me know how to get around these issues? Do you think it’s because of the version of the SSMS 20.2?

Read more here: Source link