Saturday, February 25, 2012

Changing MSDE from Win NT authentication to Mixed

Hi,
is there a way to change MSDE from Win NT authentication only to Mixed mode
authentication without reinstalling and without Enterprice Manager?
Hi,
Modify the below registry key value to 2 and restart the MSSQL Server
service.
HKLM\SoftWare\Microsoft\MSSQLSXERVER\MSSQLSERVER\
LoginMode=1 (NT Autentication)
LoginMode=2 (Mixed Mode)
Thanks
Hari
SQL Server MVP
"Olav" <Olav@.discussions.microsoft.com> wrote in message
news:E2D80B73-B1BC-4FA0-94AC-D5156168DCAC@.microsoft.com...
> Hi,
> is there a way to change MSDE from Win NT authentication only to Mixed
> mode
> authentication without reinstalling and without Enterprice Manager?

No comments:

Post a Comment