question

SriGurugubelli-3872 avatar image
0 Votes"
SriGurugubelli-3872 asked SamaraSoucy-MSFT commented

Synapse linked service (Amazon Redshift) - Connection issue

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?

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered SamaraSoucy-MSFT commented

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://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture#gateway-ip-addresses

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Sri,

I'm just checking in- were you able to update the firewall in Redshift or are you still facing permissions issues?

0 Votes 0 ·

Hello!

Following up to see if the above suggestion was helpful. Please let me know if you have any additional questions.

0 Votes 0 ·