Here you will find the steps necessary to change your SQL 2005 Authentication mode manually on the fly as opposed to scripting the process.
Follow the steps below to change your server’s authentication mode:
1. Connect to your Database Server and open the SQL Server Management Studio applet.
2. Logon to the database server as necessary and then select your SQL Server Name.
3. Right mouse click on it and from the context menu select “Properties”.
4. Select the “Security” tab on the left and then select the “Server authentication” leaf radial button for either of the following as needed:
Windows Authentication Mode
SQL Server and Windows Authentication Mode
5. Click “OK” to make the change.
6. Finally select “OK” once again to restart the SQL server services.
Note: At the dialog box that states "Some of your configuration changes will not take effect until SQL server is restarted" click “OK” and then reboot the server.
No Comments