'Windows logins are not supported in this version of SQL Server' while trying to connect to a database

Aishani Patil 20 Reputation points
2023-11-07T15:19:26.38+00:00 
Microsoft.Data.SqlClient.SqlException (0x80131904): Windows logins are not supported in this version of SQL Server.
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at Microsoft.Data.SqlClient.SqlRetryLogicProvider.ExecuteAsync(Object sender, Func`1 function, CancellationToken cancellationToken)
   at Microsoft.Data.SqlClient.SqlRetryLogicProvider.ExecuteAsync(Object sender, Func`1 function, CancellationToken cancellationToken)
   at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<<OpenAsync>b__0>d.MoveNext() in /_/src/Microsoft.SqlTools.ManagedBatchParser/ReliableConnection/ReliableSqlConnection.cs:line 319
--- End of stack trace from previous location ---
   at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in /_/src/Microsoft.SqlTools.ServiceLayer/Connection/ConnectionService.cs:line 705
ClientConnectionId:4b1fcc1f-4a58-4d1f-90c8-149d4c9511b3
Error Number:40607,State:1,Class:20

User's image

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,060 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,584 questions
Accepted answer
  1. AniyaTang-MSFT 11,256 Reputation points Microsoft Vendor
    2023-11-08T02:46:58.81+00:00

    Hi @Aishani Patil

    I found these similar threads based on your error message.

    https://stackoverflow.com/questions/51205782/how-to-resolve-azure-windows-logins-are-not-supported-in-this-version-of-sql-se

    https://stackoverflow.com/questions/64002224/ssms-windows-logins-are-not-supported-in-this-version-of-sql-server

    If these do not resolve your issue, please provide more details. For example, your environment, your operations, etc.

    Best regards,

    Aniya

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 36,086 Reputation points
    2023-11-08T06:30:30.2+00:00

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

    And which type & version of SQL Server are you using?

    If it's SQL Azure Database: As the message clearly says, not supported, you have to use SQL or Azure auth.

    0 comments