Forum Discussion
Connect data from Amazon AWS Services
Hi,
I am still getting this following error message when I try to connect Power BI to AWS with the Redshift connector- Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "ec2-34-215-220-108.us-west-2.compute.amazonaws.com" (34.215.220.108) and accepting
TCP/IP connections on port 5439?
"
I have added an inbound rule to the AWS EC2 server for port 5439 with the source as 0.0.0.0/0
What changes do I have to do? Any suggestions?
Thank you in advance!
skaranth10 Is this just a SQL Server running in AWS or something else? Generally when I put in firewall rules for Azure I have to specify the exact IP address of the host that is connecting. There is a button I believe to add client ID. Would think there would be something similar for AWS. Network firewall rules aren't my forte though quite honestly.