This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
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.