Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

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

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 ...
suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

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-virtual-machine/

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

 

Thanks