SQL Server Authentication Configuration

You are viewing documentation for a version of Secret Server that is no longer supported. Delinea supports Secret Server for one year after release. This version has passed that window and will no longer receive updates. We strongly recommend upgrading to a supported version. Visit the current version of this page for the latest documentation.
For release dates, end-of-support timelines, and upgrade guidance, see the Secret Server Product Lifecycle page.
You can view the latest version of the Secret Server documentation here.

SQL Authentication requires:

  • Creating a new SQL account
  • Enabling mixed mode
  • Enabling named pipes and SQL Browser a non-local SQL Server
For instructions on Creating the SQL account or Installing SQL Server see Installing and Configuring SQL Server article.

Enabling Mixed Mode

  1. Connect to SQL Server in SQL Management Studio.

  2. Right click on the instance node and select Properties.

  3. Go to the Security tab.

  4. In the Server Authentication section, select SQL Server and Windows Authentication Mode.

  5. Click the Ok button.

  6. Restart the SQL Server, by right clicking on the instance node and selecting Restart.

If your SQL server is running on a separate machine, you need to turn on named pipes and SQL browser to ensure the SQL server can be accessed from an external machine.

Enabling Named Pipes and SQL Browser

  1. Open SQL Server Configuration Manager.

  2. Click the SQL Server Network Configuration node.

  3. Select Protocols for MSSQLSERVER.

  4. Enable the following:

    • Shared memory

    • Named pipes

    • TCP/IP

  5. Enable SQL Browser.

  6. Click to select the SQL Server Services node.

  7. Right click SQL Server Browser and select Start.