Forum Discussion
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...
magnifybi , In SQL Server configuration Manager -> Under Network -> Enable TCP/IP and Open properties, there you need mention port, that you want use externally
Hi magnifybi ,
You can use servername or ip address+port(1433 for default instance). Would you please check if the browser service works well in server where the sql server is installed. And make sure you have enable TCP/IP protocol in sscm:
And also refer to the steps in https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai