SQL Server
SQL Server
Follow these steps to connect SQL Server to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type SQL Server into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the host name or IP address of the Server running SQL Server.
-
Enter the port for connecting to the SQL Server server in the Port field.
-
Enter the name of the Database to connect to.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Password
-
Enter the SQL Server username for authentication in the User field.
-
In the Password field, enter the user password.
-
At the top of the CData Connect Cloud Add SQL Server Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzurePassword
-
Enter the SQL Server username for authentication in the User field.
-
In the Password field, enter the user password.
-
Enter the Azure Tenant Id found on the Overview page of the OAuth app used to authenticate to Microsoft SharePoint on Azure.
AzureAD
-
Enter the Azure Tenant Id found on the Overview page of the OAuth app used to authenticate to Microsoft SharePoint on Azure.
-
Click Sign in to connect securely through OAuth. This action opens the SQL Server sign-in page in a new tab.
-
Log into your SQL Server account and provide the requested permissions (if applicable).
-
At the top of the CData Connect Cloud Add SQL Server Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Azure Service Principal
-
Copy the client Id from SQL Server and paste it in the OAuth Client Id field in CData Connect Cloud.
-
Copy the client secret from SQL Server and paste it in the OAuth Client Secret field in CData Connect Cloud.
-
Enter the Azure Tenant Id found on the Overview page of the OAuth app used to authenticate to Microsoft SharePoint on Azure.
-
At the top of the CData Connect Cloud Add SQL Server Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and SQL Server, see this information page.