Sometimes we install Sql Server on our PC with Windows Authentication mode only and Later we realise that Sql Server Authentication mode is not working. So, we require to change Sql Server Authentication Mode to login through the specific user.
To change authentication mode through Sql Server Management Studio, We need to follow the below steps -
1. Open SQL Server Management Studio and then Object Explorer, right-click the server, and then click Properties.
2. On the Security page, under Server authentication, select the "Sql Server and Windows authentication mode" and then click OK.
After changing this, We need to restart the Sql Server service. To know how to restart the Sql Server service visit the below link -
Restart Sql Server Service
Tuesday, October 20, 2015
How to change Sql Server Authentication mode using Sql Server Management Studio
10:30 PM Manish Rai Sql Server
About the Author
Author & Editor