SQL Server Authentication Configuration

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.