Synapse linked service (Amazon Redshift) - Connection issue

Question

Hi ,

Trying to create a linked service in Synapse Studio
While test connection throwing below error. Can some one help.

Error code
9603
Details
ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "---redshift-rds.c1iaphtcvqvg.us-east-1.redshift.amazonaws.com" (.8*.*0.**) and accepting TCP/IP connections on port 5439?

Answer 1

Hi Sri,

I'm not as familiar with Redshift as I am with Synapse, but in general when I've seen database connection errors like this it is usually because of a permissions issue on the target database. It looks like the AWS docs also suggest this as a probably cause of the error: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-refusal-failure-issues.html

If you need Synapse's outbound IP address list, the latest list is available here by region. It is better to use the subnets instead of specific IP addresses so you won't have to update your firewall if a particular gateway is updated to a new IP. https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture#gateway-ip-addresses

Please let me know if this helps to resolve your error.