Forum Discussion

Resolver I

5 years ago

Solved

Help connecting External SQL Express to Power BI

Hey, I need to access an external SQL Express server but am getting and error message; "Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a con...

Need Help

amitchandak
5 years ago
magnifybi , In SQL Server configuration Manager -> Under Network -> Enable TCP/IP and Open properties, there you need mention port, that you want use externally

https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver15

amitchandak

Super User

5 years ago

magnifybi , In SQL Server configuration Manager -> Under Network -> Enable TCP/IP and Open properties, there you need mention port, that you want use externally

https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver15

Forum Discussion

Help connecting External SQL Express to Power BI

Related content

Warehouse external connectivity via Service Principal

connect fabric table externally

RLS Expression Evaluation Failed - Failed connection

External Data Properties

Connections not showing for external user