Lesson Learned #362: Keyword or statement option 'default_language' is not supported in this version

[Jose_Manuel_Jurado]

Today, we got a new service request that our customer faced the following error message: Error SQL72014: .Net SqlClient Data Provider: Msg 40517, Level 16, State 1, Line 2 Keyword or statement option 'default_language' is not supported in this version of SQL Server. Error SQL72045: Script execution error. The executed script: 

CREATE LOGIN [XYZ\\User1]
FROM WINDOWS WITH DEFAULT_LANGUAGE = [us_english];

Our customer is using a bacpac to restore to Azure SQL Database, but, is failing due to the login that is mapped with windows authentication and Windows authentication is not supported for azure SQL DB. 

In this situation, we suggested to our customer the following steps: 

• Restore the DB to new on-prem server and drop the logins and export again.
• Import the data in Azure SQL Database.
• Create the logins and users on the database.

As discussed, Windows authentication is not supported on Azure SQL DB. Once we imported the database you can create the AAD user login using the below T-SQL queries, More details in the reference document CREATE USER (Transact-SQL) - SQL Server | Microsoft Learn