Synapse linked service (Amazon Redshift) - Connection issue

Sri Gurugubelli 1 Reputation point
2021-06-21T03:17:09.93+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,346 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samara Soucy - MSFT 5,051 Reputation points
    2021-06-22T01:40:06.087+00:00

    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.