Unable to Connect to SQL Server on AWS - Power BI Desktop

[manoj_0911]

Details:

I'm encountering an error while trying to connect to a Microsoft SQL Server hosted on AWS in Power BI Desktop. The error message states:

"Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)""

Troubleshooting Steps Taken:

* Verified that the SQL Server on AWS is running.
* Double-checked the username and password in Power BI (and confirmed they have appropriate database access).
* Reviewed the Security Group settings for the EC2 instance and ensured an inbound rule allows traffic on port 1433 from my computer's IP address.
* Checked for any firewall restrictions on my local machine or within AWS that might be blocking the connection.

I'm new to both PowerBI and AWS, Please help on this

[rajendraongole1 · Accepted solution]

Hi @manoj_0911 -The error message you encountered indicates that Power BI Desktop cannot establish a connection to your Microsoft SQL Server hosted on AWS.

your SQL Server instance on AWS is configured to listen on port 1433.Verify that SQL Server is set to allow SQL Server authentication and Windows authentication.Double-check that the Security Group associated with your EC2 instance allows inbound traffic on port 1433 from your IP address. This includes ensuring the rule is set to allow TCP traffic.

Please go through the below links for more details.

Control traffic to your AWS resources using security groups - Amazon Virtual Private Cloud

Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AW...

https://wciconsulting.com/resources/power-bi-to-aws-sql-server-connection-tutorial/

Hope the above details are helpful.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!