Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing between Windows and Mixed authentication
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01260085
Message ID:
01260092
Vues:
12
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform