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

Article:HOWTO9286  |  Created: 2008-07-30  |  Updated: 2011-04-20  |  Article URL http://www.symantec.com/docs/HOWTO9286
Article Type
How To



Question

These below instructions are taken directly from Microsoft's website. For further detail, please go to http://msdn.microsoft.com/en-us/library/ms188670.aspx.



Answer

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



43268


Article URL http://www.symantec.com/docs/HOWTO9286


Terms of use for this information are found in Legal Notices