Help connecting to a server using Windows authentication on a virtual machine using Power BI

[Syndicate_Admin]

Hello, good afternoon

I'm having a problem and would appreciate your help. I'm trying to make a connection to my SQL Server using Windows authentication from a virtual machine, but I'm not sure how to proceed correctly. I have set up an On-premises Data Gateway on my server to allow access to the data, as shown in the attached images. However, I don't know how to work with that connection from Power BI Desktop outside the server (on my local machine).

I tried connecting using Power BI Gateway, but I'm not sure if the setup is correct or if I need to do anything additional to work with the data from Power BI Desktop in an on-premises environment. Has anyone had a similar experience or knows what additional steps I need to take to get the connection working properly?

Thank you in advance for any suggestions or advice you can give me.

[Anonymous]

Hi @Syndicate_Admin ,

May I ask if you have gotten this issue resolved?
This post has been marked as a solution in the original community.
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .

Thank you very much for your kind cooperation!

Best Regards,
Dengliang Li

[suparnababu8]

Hi @Syndicate_Admin 

I will walk through the steps to ensure your setup is correct and that you can connect to your SQL Server using Windows authentication from your virtual machine.

Steps to Connect SQL Server Using Windows Authentication

1. Enable TCP/IP Protocol:

   • Open SQL Server Configuration Manager on your virtual machine.
   • Navigate to SQL Server Network Configuration > Protocols for [Your SQL Instance].
   • Ensure TCP/IP is enabled.

2. Configure Firewall:

   • Open Windows Firewall on your virtual machine.
   • Create a new inbound rule to allow traffic on port 1433 (default port for SQL Server).

3. Set Up On-premises Data Gateway:

   • Ensure your On-premises Data Gateway is correctly installed and configured on your server.
   • Verify that the gateway is online and connected.

4. Connect from Power BI Desktop:

   • Open Power BI Desktop on your local machine.
   • Go to Home > Get Data > SQL Server.
   • Enter the server name and database name.
   • For Authentication Method, select Windows.
   • Ensure you are using the correct credentials that have access to the SQL Server.

If you need more information pls go through the follow URLs

https://www.mssqltips.com/sqlservertip/6366/how-to-connect-remotely-to-sql-server-on-an-azure-virtua...

https://www.youtube.com/watch?v=AvRUWFq-9ZA

Thanks