Forum Discussion
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Thanks for the kind reply. I couldn't figure out how this could be relevant. I am not using Dataflow Gen2 in my Fabric data flow. Also my data is already in a lakehouse and I am trying to connect it to Power BI. If it was a firewall issue I should've had the issue when connecting directly using OneLake data hub direct method. The issue only rises when I try to use the SQL Analytics Endpoint of the same Lakehouse.
Hi SS_Analyst ,
Base on your description, it seems like it got error when connect to SQL Endpoint. Could you please check and verify the following info?
1. Enable remote connections
2. Verify SQL Server Network Configuration
TCP/IP Settings in SQL Configuration Manager
3. Check SQL Server Browser Service is running
4. Configure Windows Firewall
How To: Configure Windows Firewall for SQL Server
Best Regards
Hello again,
Thanks for the kind reply! Unfortunately I don't think this can help me either. I am not connecting to SQL data base that I admin, but Microsoft Fabric data lakehouse SQL endpoint. There is absolutely nothing to configure and as I said in my previous comment if I connect directly to the lakehouse there is no problem. The problem rises when I am using the SQL Analytics Endpoint of the lakehouse.i still think that the blockage on port 1433 for these endpoints is the cause.