How to change my authentication in SQL 2005 once already configured?

Article:HOWTO9286  |  Created: 2008-07-30  |  Updated: 2011-04-20  |  Article URL
Article Type
How To


These below instructions are taken directly from Microsoft's website. For further detail, please go to


To change security authentication mode

1.    In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

2.    On the Security page, under Server authentication, select the new server authentication mode, and then click OK.

3.    In the SQL Server Management Studio dialog box, click OK, to acknowledge the need to restart SQL Server.

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices