gaborgsomogyi/MS SQL server authentication method.md

Created February 27, 2020 18:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gaborgsomogyi/c4a9c3e351dcd6094c6a39a4aede0f1a.js"></script>
Save gaborgsomogyi/c4a9c3e351dcd6094c6a39a4aede0f1a to your computer and use it in GitHub Desktop.

Raw

MS SQL server authentication method.md

To read what kind of authentication method is used:

sqlcmd -S example.com -U sa -P Mssql123 -Q "EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode'"

LoginMode values:

1: Windows Authentication
2: SQL Server and Windows Authentication mode

To set it:

sqlcmd -S example.com -U sa -P Mssql123 -Q "EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2"