Connect power bi report to SQL server on computer where I remote login to

[Anonymous]

Hello, so I remote login to anothr computer to access their database in Microsoft SQL server management. I want to connect a new report in power bi on my physcial computer to that server, but every time I try to it won't work. Any one experience something similar, or have any solutions? 

[Anonymous]

I am working in Microsoft SQL Server Management Studio, will this still work for me? On my computer I cannot find SQL Server Configuration Manager. 

[Anonymous · Accepted solution]

Hi @Anonymous ，

We first need to troubleshoot the problem you are experiencing step by step, first make sure you have both SSMS and SQL Server downloaded,

if one of them is missing it may cause you to not find SQL Mannager.

We have several ways to help you find SQL Mannager.

In your local folder find C:\Windows\System32.

Open the Run dialog box by pressing Win + R.

Type and press Enter. Replace the version number with the version number of SQL Server: SQL Server Manager<version>.

If you don't know your version number, there are links you can check that may help you.

Determine which version and edition of SQL Server Database Engine - SQL Server | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[Shravan133]

Verify SQL Server Accessibility

Make sure that the SQL Server is configured to allow remote connections:

1. Allow Remote Connections:

   • Open SQL Server Management Studio (SSMS) on the remote computer.
   • Right-click on the server name in Object Explorer and select 'Properties'.
   • Go to the 'Connections' page and ensure 'Allow remote connections to this server' is checked.

2. Check SQL Server Configuration Manager:

   • Open SQL Server Configuration Manager on the remote computer.
   • Expand 'SQL Server Network Configuration' and click on 'Protocols for [Your Instance]'.
   • Ensure that 'TCP/IP' is enabled. Right-click on 'TCP/IP', select 'Properties', and make sure it is enabled.
   • In the 'IP Addresses' tab, check that TCP/IP is enabled for all relevant IP addresses.

3. Firewall Settings:

   • Ensure that the firewall on the remote computer allows incoming connections on the port used by SQL Server (default is 1433).
   • You may need to add an inbound rule to the firewall to allow connections on this port.

2. Configure SQL Server Authentication

Ensure that you have the correct authentication mode and credentials to connect:

1. Mixed Mode Authentication:

   • In SSMS, right-click the server name, select 'Properties', and go to the 'Security' page.
   • Ensure 'SQL Server and Windows Authentication mode' is selected.

2. Create a SQL Server Login:

   • In SSMS, expand 'Security' and right-click 'Logins', then select 'New Login'.
   • Create a new login with the appropriate permissions to access the database you need.