DEFINITIONS

Definitions More Info.
Definition ID4.043
TitleSQL
CategoryNOTES
Definitionchange sql server authenticaiton mode to mix authenticaton in command promt
Definition Descriptionhttps://social.msdn.microsoft.com/Forums/sqlserver/en-US/543abeee-d12c-450f-b9c1-959f9e97d835/what-sqlcmd-to-use-for-changing-windows-authentication-mode?forum=sqlexpress

once sql server installaiton ISO ya media sini mount edin
Adminsitrator olarak siyah ekran command promt acin
Media yi mount ettiginiz driver girin ornek E: drive
sonra asagidaki komutu calisitirin.

sqlcmd.exe -S HPCUNAY-HOME -d master -Q "EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2"
RecordBycunay
Record Date17-12-2020 14:56:33
Düzenle
Kopyala
Sil