Tuesday, October 20, 2015

How to change Sql Server Authentication mode using Sql Server Management Studio

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



About the Author

Manish Rai

Author & Editor

I am Manish Rai an IT Professional, I started the www.einfoportal.com at the beginning of 2013.My goal is to establish www.einfoportal.com as a information portal that will help every individual(s) to get the information related to their day by day activities and use this information for the good purpose. I love to share my knowledge with the people. Follow me on Facebook | Google+ | Twitter

0 comments:

Post a Comment

 
Copyright © www.einfoportal.com . All Rights Reserved