...
Double click the "ConnectMyApps CloudConnector MSQL" icon on the desktop. A login screen will appear. You must enter your ConnectMyApps login licence email and the 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".//Image missing from zendesk????
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.
NB:
The integration requires to run stored procedure "Oko_UpdateBuntHode" with the SQL user. The roles "db_datawriter" and "db_datareader" need to be activated.
4. Provide Connection Information
...
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 and database(s) name.
As this is sensitive information we do not recommend that you simply email this to our support team. Instead we recommend that you use our Secure Share facility, located here: https://www.connectmyapps.com/secureupload
...
. 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.