While configuring your Azure SQL, connection, you may encounter several issues. Understanding these common errors can help streamline the setup process and facilitate quick resolutions.
An IP address is not whitelisted
This error occurs when the IP address of the device or server attempting to connect is not included in the whitelist.
Using External Tools for Database Connection:
- Try connecting to your database using external tools such as DBeaver. This will help confirm if the issue is related to your database configuration.
Check Firewall Settings:
- If your database is behind a firewall, ensure that our service's IP addresses are whitelisted.
- In the connection parameters, select the option "Use static IP = YES" to ensure a stable connection to your database via a static IP address.
Wrong host or port number
This error occurs when the specified host address or port number is incorrect, preventing a successful connection.
Verify Host and Port Information:
- Double-check the host address and port number you have entered. Ensure they exactly match the details provided by your database service.
- Confirm that there are no typographical errors and that the correct format is used for the host address and port number.
Check Firewall and Network Settings:
- If your database is protected by a firewall, verify that our service's IP addresses are added to the whitelist to allow connections.
- In the connection parameters, select the option "Use static IP = YES" to ensure a stable connection to your database via a static IP address
- Attempt to connect to the database using a different network or machine to rule out local network issues.
- If you continue to experience issues, consider resetting or recreating your database connection settings.
Missing database permissions
This error occurs when your database does not have the necessary permissions to perform certain actions or access specific resources.
Grant Required Permissions:
- Check the permissions currently assigned to our database within your system. Ensure that it has the necessary permissions as specified in our documentation
- Permissions needed may include ```READ```, ```WRITE```, ```EXECUTE```, or administrative rights, depending on the specific requirements of the tasks our database needs to perform.