Provide the best software to recover passwords for
Windows, SQL Server, PDF, Word, Excel, Outlook, FTP, Email, etc.
Home > SQL Server Password Changer > Change SQL Server Authentication Mode

2 Options to Change SQL Server to Mixed Mode Authentication

It is considered best practice to configure SQL Server instance to allow only Windows authentication. However, some situations require that SQL Server authentication be used. In this article we'll explain two methods to change SQL Server to mixed mode authentication after installation.

Option 1: Enable Mixed Mode Authentication in Management Studio

As long as you can connect to SQL Server with Windows authentication, you can enable mixed mode authentication easily using SQL Server Management Studio.

  1. Login into SQL Server with SQL Server Management Studio.
  2. In Object Explorer, right-click the name of the server that you wish to reconfigure and select Properties from the menu that appears.

    SQL Server Management Studio

  3. This displays the Server Properties dialog box. Select the Security tab and you can then choose SQL Server and Windows Authentication mode (also known as mixed mode authentication).

    Change SQL Server authentication mode

  4. Click OK to save the changes and restart the SQL Server service.

Option 2: Enable Mixed Mode Authentication from Registry

If you don't have sufficient privileges to enable the mixed mode or couldn't login with Windows authentication, you can enable mixed mode authentication with a registry fix.

  1. Press the Windows key + R to bring up the Run box. Type regedit and press Enter.
  2. Navigate to the registry location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQLServer, where MSSQL12.SQLEXPRESS is the name of your SQL Server instance.
  3. In the right panel, change the LoginMode from 1 to 2. 1 = Windows authentication Only. 2 = Mixed mode.

    Enable mixed mode authentication in SQL Server

  4. Restart your SQL Server instance and you can then connect to the server by using SQL Server Authentication.

If Windows authentication mode is selected during installation, the SA login is disabled and a password is assigned by setup. If you later change SQL Server to mixed mode, the SA login remains disabled. With SQL Server Password Changer you can reset lost SA password and unlock SA account easily.

Related Articles