Search
InstantDoc ID
GO

Browse By: Author | Issue

January 24, 2002 04:24 PM

Changing MSDE's Security Mode

Rating: (0)
Brian Moran
SQL Server Magazine
InstantDoc ID #23503

I have a copy of Microsoft SQL Server Desktop Engine (MSDE) installed on a Windows 2000 Professional PC. By default, MSDE is configured to use Windows authentication. The database developer didn't provide an MSDE management utility to let us change the security mode. Can we change the authentication mode to SQL Server authentication?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

On MSDE 2000 Release A I found the Registry path to be: HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSSQLServer\\MSSQLServer\\LoginMode


Anonymous User 6/13/2005 5:55:09 PM

Extremely help full... I feel like kissing you :D

Anonymous User 3/3/2005 10:27:31 AM

excellent - MS has the value wrong in the KB that I find!

Anonymous User 2/9/2005 7:53:31 AM

Extremly help full and Simply Great .....
Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....Extremly help full and Simply Great .....

Anonymous User 1/21/2005 5:59:55 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.