SQL Server Error Msg 40607 – Windows logins are not supported in this version of SQL Server.

In this blog post, let’s learn about the error message “40607 – Windows logins are not supported in this version of SQL Server.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

40607 – Windows logins are not supported in this version of SQL Server.

Reason for the Error

The SQL Server Error Msg 40607 occurs when you try to create or update a login using a Windows login or a Windows group in a SQL Server version that doesn’t support Windows logins. This error is usually seen when trying to create or update a login in Azure SQL Database or Azure SQL Managed Instance.

Here’s an example of the SQL Server Error Msg 40607:

Suppose you try to create a login using a Windows login or group in Azure SQL Database:

CREATE LOGIN [DOMAIN\Username] FROM WINDOWS;

This will trigger the SQL Server Error Msg 40607, which will look like this:

Msg 40607, Level 16, State 1, Line 1
Windows logins are not supported in this version of SQL Server.

This error message indicates that the version of SQL Server being used does not support Windows logins or groups. In this case, you’ll need to create a SQL Server login instead.

Solution

Try creating an SQL Server Login instead.

Here’s how you can create a SQL Server login:

CREATE LOGIN [MyLogin] WITH PASSWORD = 'MyPassword';

If you need to grant permissions to the login, you can create a user in a database and associate it with the login:

USE [MyDatabase];
CREATE USER [MyUser] FOR LOGIN [MyLogin];

In summary, SQL Server Error Msg 40607 occurs when you try to create or update a login using a Windows login or group in a SQL Server version that doesn’t support Windows logins. The error message provides information about the problem and suggests using a SQL Server login instead. To fix the error, create a SQL Server login and associated user if necessary.