Sunday, August 29, 2021

How to change SQL Server to Mixed Mode Authentication using t sql

EXEC xp_instance_regwrite
    N'HKEY_LOCAL_MACHINE'
    , N'Software\Microsoft\MSSQLServer\MSSQLServer'
    , N'LoginMode'
    , REG_DWORD, 2
go

restart sql server

No comments:

Post a Comment