How To Change Server Authentication Mode In SQL Server 2008

This article describes how to change the server authentication mode in SQL Server.
  • 1443

This article describes how to change the server authentication mode in SQL Server. While installing SQL Server, if you select windows authentication mode and Server authentication mode is disabled.

To change authentication mode from windows authentication to SQL Server authentication mode, follow given steps:

Step 1

Go to SQL Server Management Studio Object Explorer. Right-click the server, and then click Properties.

AuthenticationMode01.jpg

Step 2

On the Security page, you will find "Server Authentication" section. Select the new server authentication mode, and then click OK.

AuthenticationMode02.jpg

Step 3

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

AuthenticationMode03.jpg

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.