>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.