Portal for Support Agents

How to change SQL Server Authentication to mixed mode

If you are unable to connect, please verify that your SQL Server Authentication is in mixed 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.