---
title: "Enable mixed mode authentication SQL Server"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/1393393687/Enable%20mixed%20mode%20authentication%20SQL%20Server"
format: markdown
---
## Change authentication mode with SQL Server Management Studio

1. In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select **Properties**.
2. On the **Security** page, under **Server authentication**, select the new server authentication mode, and then select **OK**.
3. In the SQL Server Management Studio dialog box, select **OK** to acknowledge the requirement to restart SQL Server.
4. In Object Explorer, right-click your server, and then select **Restart**. If SQL Server Agent is running, it must also be restarted.

> ⚠️ This will require the SQL Server instance to restart. Any database connections at the time of the restart will be terminated.