This article provides information on ways to connect Azure SQL (SaaS) and SQL on Azure to Solver Cloud as well as troubleshooting for common issues/errors.
For Azure SQL (SaaS)
Note: We pass off authentication credentials via the SQL connector. There is no difference if the SQL server is internal and the end user is trying to connect to this server from their local machine. The only difference is the SQL database in Azure can be publicly accessible, while on-premise typically is not.
- Gateway
- Gateway will work but it’s recommended to use SQL Connector.
Note: A port will need to be opened on Azure SQL to allow for communication.
- Gateway will work but it’s recommended to use SQL Connector.
- SQL Connector
- Users can connect directly from Cloud as it is on the same named network.
- Server address should be in the format as shown on the below screenshot.
Note: Currently we only support Active Directory and SQL authentication. Azure AD is not currently supported.
For SQL database hosted on Azure
- Gateway
- The user will need to configure a firewall rule or setup a VPN – an FQDN or IP address assuming they integrate it into their existing network and maintain a connection.