Does Azure SQL Server support SSPI authentication?

Question

Hello,

I'm seeking assistance regarding confirmation. Does SSPI authentication, which is Windows-based authentication, have support for Azure SQL Server? While exploring, I observed that SSPI authentication is supported for Azure SQL Managed Instance. Could you please confirm whether SSPI authentication is supported for Azure SQL Server or Azure SQL on VM?

Answer 1

Yes, Windows Authentication (SSPI) is supported on Azure SQL Managed Instance, but it requires some additional steps to set up as explained here. Windows Authentication allows you to use your existing Active Directory (AD) credentials to access Azure SQL Managed Instance, without having to create SQL logins or store passwords in connection strings

Answer 2

Hi, @Darwin Wilmut J Thanks for posting your question in the Microsoft Q&A forum

On checking with the Internal team Yes, SSPI authentication is supported for Azure SQL Managed Instance. However, it is not supported for Azure SQL Server or Azure SQL on VM.

These are supported authentication options for Azure SQL Database and AAD you can find from the below document.

https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver16

Regards

Geetha