Remote connection to MS SQL server which listens only dynamic ports

[Karthik12]

Hello Guys,

Hope you are doing well !

I am trying to commect power bi to a MS SQL database which is installed in shop floor PC of a testing machine. 

But, couldn't be successful. It will be great pleasure if I could any support from community.

I have done following steps and let me know if anything needs to be done additionally.

1. Connected SQL PC in a network

2. Enabled TCP/IP under network connection in SQL server manager. 

3. Firewall turned off completely.

4. SQL server management studio, created a log in my name.

5. Checked "Allow remote connection" also.

6. Server and windows authetication setting selected.

went to Power bi in my PC and get data -> SQL server database and typed server name.

and login selected - data base then input log in and password created earlier.

But, I couldn't connect. Please support !

[Karthik12]

Hi @v-yangliu-msft I have done it and sent = 4 and received = 4 and % of loss = 0. S0 which means there is no issue with server machine and my machine

[v-yangliu-msft]

Hi  @Karthik12 ,

You can try the following operation:

Check Network Connectivity: Ensure that you can ping the SQL Server machine from your computer. Open Command Prompt and type ping <SQL_Server_IP_Address> (replace <SQL_Server_IP_Address> with the actual IP address of the SQL Server machine). This will verify that there is network connectivity between your computer and the SQL Server.

Check Service port if connected ping Ip port.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.