Connecting CloudBees CD to a Microsoft SQL Server Named Instance

If you are using a named instance of the SQL server, you need to configure the SQL server to listen on specific port so that the CloudBees CD server can connect to it.

  1. In SQL Server Configuration Manager, expand the SQL Server Network Configuration, and click on the server instance that you want to configure.

  2. In the right pane, double-click TCP/IP.

  3. In the TCP/IP Properties dialog box, click the IP Addresses tab.

  4. In the IPAll section, enter an available port number in the TCP Port field.

    For example, enter 1433.

  5. Click OK to close the dialog box.

  6. When a prompt appears that the server must be restarted, click OK.

  7. In the left pane, click SQL Server Services.

  8. In the right pane, right-click the instance of SQL Server that you selected in Step 1, and click Restart.

    When the Database Engine restarts, it will listen on port 1433.

    sqlsrvinstance1

  9. Enable TCP/IP.

    sqlsrvinstance2