Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing between Windows and Mixed authentication
Message
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01260085
Message ID:
01260092
Views:
11
>Hi all,
>
>Is it possible to change authentication models in SQL 2005 after installation, or must I reinstall the software to switch from Windows authentication to mixed-mode authentication?
>
>TIA,

Run SSMS
Connect to your server
Right Click on the Server in Object Explorer
Click on Security Node
Change the authentication method.
I am not sure if the SQL Server service must be restarted, but to be sure you can do that :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform