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?
Saturday, February 25, 2012
Changing MSDE from Win NT authentication to Mixed
Labels:
authentication,
changing,
database,
enterprice,
microsoft,
mixed,
modeauthentication,
msde,
mysql,
oracle,
reinstalling,
server,
sql,
win
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment