Connecting to Microsoft SQL Server

In order for ConnectMyApps to integrate with Microsoft SQL Server a number of steps must be followed on the machine hosting the Microsoft SQL Server instance. 

The following steps must be completed:

1. Installing ConnectMyApps CloudConnector

The ConnectMyApps CloudConnector for MSSQL is a software application that allows encrypted communication between the MSSQL database and the ConnectMyApps integration platform. CloudConnector must be installed on the same machine where the MSSQL instance is installed, or on a machine that can make an ODBC connection to the instance.

The CloudConnector application itself can be downloaded via a link from the ConnectMyApps support team. Please contact the team at support@connectmyapps.com to get the link.

Installation is simple. After download, simply right-click the installer, choose "Properties" and tick "Unblock" and then "OK". Then double-click to run the installer. Installation should take only a minute and will complete automatically. You should see a "ConnectMyApps CloudConnector MSSQL " icon on the desktop after installation.

Please note that there should be no need to add exceptions to your firewall. CloudConnector makes an outbound encrypted connection so usually does not require any inbound configuration.

Minimum requirements for CloudConnector

• Windows Server 2008 or higher

• SQL Server 2012 or higher

• .NET full framework 4.6.1 or higher

• Min 4GB RAM

• 50 MB of hard drive space

2. Copy the CloudConnector Key

Double click the "ConnectMyApps CloudConnector MSQL" icon on the desktop. A login screen will appear. You must enter your ConnectMyApps licence email and licence key as provided by ConnectMyApps support. If you have not received a licence key please contact support@connectmyapps.com.

In the next screen, after licence key activation, you will see the CloudConnector key. Press the "Copy" link to copy the key to your clipboard. You can then "Close".

3. Create a SQL Login

You must provide a SQL login for the connector. This can either be an existing login or a new one that you create. We recommend creating a new one. You must give the login access to the desired database(s) and ensure they have sufficient role privileges to be able to read from the database (e.g. role "dbdatareader"). It is important to understand that the Connector will have the same database rights as the login, so you should only give it the minimum of what it needs. You may check with ConnectMyApps Support Team if you are unsure what is required.

Please note that the Connector only supports SQL Login and does not support Windows Authentication. You must ensure SQL Login support is activated on your MSQL instance.

4. Register Application in Canvas

Finally you can return to your Canvas account and register MSSQL On-Premise as an application. Go to Applications/Add new application. Search for MSSQL on-premise and click Add. In the authentication screen enter the following:

• ConnectMyApps CloudConnector key from step 2.

• SQL login username and password from step 3.

• SQL database name.

• SQL server name and instance name. For example “.\SQLExpress” for a local instance.

It should be noted that the SQL server name is the same as what you see in the “Server name” when connected with Microsoft SQL Studio.