Page Comparison

...

1. Download the installation media on the computer you are deploying to and ensure the .Net 5.x prerequisite is installed before proceeding.

2. Extract the installation media to a local folder and run the msi file in the CloudBridgeClient.Installer folder.

3. Click next through the installation prompts to deploy the software. When finished, you will find the Cloud Bridge application files in “C:\Program Files\Square 9 Softworks\CloudBridge”.

Configure Cloud Bridge

Creating New Service Mappings

1. From the Cloud Bridge application folder (C:\Program Files\Square 9 Softworks\CloudBridge), run the Cloud Bridge client (CloudBridgeClientUI.exe).

2. The first time you access cloud bridge, you will need to provide configuration details. Specifically, the fully qualified domain name for your GlobalSearch instance and the Cloud Bridge access password provided during the fulfillment process.
   
   If you cancel the server configuration, or need to change the configuration, click the black Server icon to the right of the Square 9 logo to open the server configuration.
   

   1. Provide the FQDN in the Server text box of the configuration form. Do not include “https://”. So the Server entry should resemble: myinstance.mysquare9.com

   2. If your are a user of Square 9’s Workflow or Capture products, your URL will resemble:

      1. capture-myinstance.mysquare9.com

   3. Customers looking to add Cloud Bridge to their environment will require a password provided by Square 9’s cloud fulfillment team. Provide that value in the Password text box.

...

• The configured URL will display to the right of the black Server icon, to the right of the Square 9 logo. If the URL is empty or incorrect, click the server icon to display the configuration panel and update it.

• If the service is running, the Running status is indicated in the upper right of the interface, along with a green check. If the connection is broken, the service is configured to stop and restart itself to reestablish the connection. If the service is not running for any reason, it will be noted as stopped in this area.

• If the Cloud Bridge client has been able to successfully broker a connection to your Square 9 Cloud environment, you will notice a security token displayed below the URL, to the right of the black server icon.

• Click the blue Plus fab icon in the bottom right corner to configure a connection.
  

  

• Provide all details for your service connection:

  • Service Name is just used for display purposes. It’s an indicator for those configuring the client what a specific service is intended to be used for.

  • Address is used to specify the network address of the service that will be exposed through Cloud Bridge. In most cases, Cloud Bridge will be installed on the same server as the service in question. In this example, we will be specifying a connection to a local SQL Server instance, so the default local address of 127.0.0.1 is acceptable.

  • If you wish to specify your own port, leave the Port selection on Custom, and provide the port number in the text box below. Alternately, Cloud Bridge is bundle with common ports / applications. You can select an application from the Port drop down list and the port number will be provided for you.

  • Clicking save will provision the connection details. Your local service will now be available to Square 9’s cloud.

    

Creating New Service Mappings

• If you need to remove a configured service, simply right click the Service Name of interest and choose the Delete option.

...

Configure Cloud Bridge to Connect to SQL Server

Configure the SQL Server to use TCP/IP

In order to access a on-premise SQL Server, the SQL Server must have TCP/IP enabled and a static port defined on the address you are binding CloudBridge to. For example, if you mapping CloudBridge to the IP Address 127.0.0.1, it must have 1433 statically defined on that IP in the TCP/IP properties. To configure this, do the following:

1. Open SQL Server Configuration Manager

2. Navigate to SQL Server Network Configuration > Protocols for YourInstanceName

3. If TCP/IP is not enabled, right click it and select Enable.

4. Right click TCP/IP and select Properties

5. Select IP Addresses

6. Locate the IP address you are binding to, and set “Enabled” to “Yes”.

7. Click OK
   

   Image Added

8. Restart the SQL Server Instance

Configure a SQL Server User and Password

Any connections from your Cloud Server to your on-premise SQL server will use SQL Authentication.

...

To configure SQL Authentication, do the following:

1. Open SQL Server Management Studio and login to your SQL Instance

2. Right click the SQL instance name and select Properties

3. Click on Security on the left

4. Ensure SQL Server and Windows Authentication Mode is enabled under Server Authentication.

5. Click OK.

6. On the navigation pane, scroll down and right click Security.

7. Select New > Login

8. Enter a login name, select SQL Server authentication and define a password.

   1. Note: Leaving password expiration on will require periodic changes of any connections from your SQL instance and is not recommended.

9. Under Server Roles and User Mapping, define any permissions your user needs and click OK.

Testing Your Configuration

If you have performed the steps above, you should be able to connect to your SQL instance as shown in the screenshot below:

...

Connecting to Your Server Over CloudBridge

When connecting to your on-premise SQL instance from your cloud server, use the following connection string as a reference.

Server=IPProvidedBySquare9,PortInCloudBridgeClient;Database=DatabaseName;UID=User;PWD=Password;

Related articles