Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Changing authentication modes

Author  Topic 

mkoleno346
Starting Member

1 Post

Posted - 2005-03-03 : 18:49:13
If I want to change autentication modes for an instance of MSDE that I already installed, what is the best way to go about this? I don't think you can change authentication modes using any of the SQL command line utilities. I read a Microsoft article explaining that the way to go about this was to change the LoginMode registry key for my particular instance. I am hesitant to go about changing authentication using this approach, because I do not know what possible conflicts that this could/would create.

Can someone please advise me on what is the best way of changing authentication modes on an already installed instance of MSDE?

Many thanks,

Mike Koleno

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-03-05 : 13:55:25
Do what the MS article says.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -