Connecting CloudBees Flow 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 Flow 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

Copyright © 2010-2020 CloudBees, Inc.Online version published by CloudBees, Inc. under the Creative Commons Attribution-ShareAlike 4.0 license.CloudBees and CloudBees DevOptics are registered trademarks and CloudBees Core, CloudBees Flow, CloudBees Flow Deploy, CloudBees Flow DevOps Insight, CloudBees Flow DevOps Foresight, CloudBees Flow Release, CloudBees Accelerator, CloudBees Accelerator ElectricInsight, CloudBees Accelerator Electric Make, CloudBees CodeShip, CloudBees Jenkins Enterprise, CloudBees Jenkins Platform, CloudBees Jenkins Operations Center, and DEV@cloud are trademarks of CloudBees, Inc. Most CloudBees products are commonly referred to by their short names — Accelerator, Automation Platform, Flow, Deploy, Foresight, Release, Insight, and eMake — throughout various types of CloudBees product-specific documentation. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Jenkins is a registered trademark of the non-profit Software in the Public Interest organization. Used with permission. See here for more info about the Jenkins project. The registered trademark Jenkins® is used pursuant to a sublicense from the Jenkins project and Software in the Public Interest, Inc. Read more at www.cloudbees.com/jenkins/about. Apache, Apache Ant, Apache Maven, Ant and Maven are trademarks of The Apache Software Foundation. Used with permission. No endorsement by The Apache Software Foundation is implied by the use of these marks.Other names may be trademarks of their respective owners. Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this content, and CloudBees was aware of a trademark claim, the designations have been printed in caps or initial caps. While every precaution has been taken in the preparation of this content, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.