Forum Discussion
Connect power bi report to SQL server on computer where I remote login to
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?
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Shravan133Super User
Verify SQL Server Accessibility
Make sure that the SQL Server is configured to allow remote connections:
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.
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.
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:
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.
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.
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.