This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing the option of changing the Authentication Mode of SQL Server from the Windows Registry.
Most of the DBAs are always trying to manage database server from the outside like Windows Powershell, Windows Registry, Shell Command prompt.
Here also, I am sharing Windows Registry path for changing the SQL Authentication Mode.
Registry Path:
|
1 |
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL13.DBRND\MSSQLServer |
There are two types of authentication modes, “Windows Authentication mode” and “SQL Server and Windows Authentication mode (Mix mode)”.
In the above path, you have to change “LoginMode” parameter. 1 = Windows Authentication mode, 2 = Mix mode.
Check the below screenshot:
