How to configure SQL Server Authentication mode SQL Server

Description

In this article I am going to explain about how to enable or configure SQL Server Authentication mode or Mixed mode Authentication in SQL Server.

Steps to Enable SQL Server and Windows Authentication mode via SQL Management Studio

1. Open the SQL Server Management Studio with an elevated privilege(Run as administrator).

How to enable SQL Server Authentication mode in SQL Server

2. Select  SQL Server instance or type the instance name (machinesqlinstancename).  then click the Connect button.

How to enable SQL Server Authentication and Windows Authentication mode in SQL Server
medianet_width=’728′; medianet_height= ’20’; medianet_crid=’812152226′;

3. Right-click on the connected server instance, and click Properties.

How to enable SQL Server Authentication mode in SQL Server 2008 R2

4. Navigate to the Security page, select SQL Server and Windows Authentication mode, and click OK

How to enable SQL Server Authentication mode in SQL Server 2008 R2

5. We need to Restart corresponding SQL Server service to take effect this change immediately.

How to enable SQL Server Authentication mode in SQL Server 2008 R2

Thanks,
Morgan
Software Developer
Advertisement

Leave a Comment