How to Change SQL Server Authentication Mode


Your are getting errors when trying to connect to the database using the built-in SQL database credentials.


During installation, SQL Server Database Engine is set to Windows Authentication mode.


Change Authentication to mixed mode.

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 requirement to restart SQL Server.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.