SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?


 

Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software works. In this blog, I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

Here is the screenshot of my problem statement. Weird, right?

Logically thinking, if a radio button group is greyed out with nothing checked which means the value is not as expected by SQL Server Management Studio (SSMS). I captured profiler and looked at the script which is executed when we click on the