...
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.
SQL login .username and password
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
...