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.
Whitelist errors
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.
Error message:
Error
Failed to connect to the server: host.
Solution
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.
Connection errors
Wrong host or port number
This error occurs when the specified host address or port number is incorrect, preventing a successful connection.
Error message:
Error
Failed to connect to the server: host.
Solution
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
Additional Troubleshooting:
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.
Permission errors
Missing database permissions
This error occurs when your database does not have the necessary permissions to perform certain actions or access specific resources.
Error message:
Error
Permission denied.
Solution
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.
Note
If none of the provided solutions worked, feel free to raise a request via the Service Desk
Schema information
Setup guide
Settings
No items found.
Troubleshooting
Troubleshooting guides
Check out troubleshooting guides for
Azure SQL - Troubleshooting
here:
Limits
Azure SQL - Troubleshooting API changes
Frequently asked questions
No items found.
Thank you for your feedback!
Oops! Something went wrong while submitting the form.