Search code examples
sql-serverazuressms

Connecting to Azure SQL Server Fails

I created a Azure SQL Database Server as shown in the image below

enter image description here

with only microsoft-entra authentication enabled, later when i try to connect to it through SSMS, it gives me the error on selecting windows authentication:

Windows logins are not supported in this version of SQL Server. (Microsoft SQL Server, Error: 40607)

Is this an issue with my local ms sql server, I had installed sql server 2022 recently and was able to connect to the localhost.

Other Questions alongside this

1] I had seen SELECT @@VERSION command returning ms sql server 2012, when I ran on azure sql database server connected through SSMS. Can we update it or can we select version when creating the database?

2] On running sqlcmd -L command in my local cmd returns "?" for all the attributes while several other stackoverflow questions had some values returned, will this cause any problems?

I am new to azure and sql, can anyone please help me with this, I am unable to get my head around this.

Solution

  • As others have said, you can't use Windows Authentication to connect to an Azure SQL Server, you need to use Azure AD (Entra ID) Authentication:

    Auth options in SSMS 19.1

    You would use 'Universal with MFA' and enter the e-mail address of the admin user you defined when you built the server, which will then open a browser window to perform the login.