Forum Discussion

rammy's avatar
rammy
Helper I
4 years ago

Using power bi How to connect company SQL server from my pc

Hi Power bi community  i am new to power bi as of now my manager gives me a task how u will access my server in remotely by doing some modifications in sql. At that time i am telling i want search ...
Need Help
rammy's avatar
rammy
Helper I
4 years ago

Hi Icey 

 

these are the errors that i got when i am tryig to access data from power bi to australia sql pc  , this error getting  while i am using  ip and port details .Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)"

 

and another one is ,this error is getting while using username and password

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

 

please help me 

Thanks in Advance 

rammy's avatar
rammy
Helper I
4 years ago

Hi Icey  

please find the below attachement and help if possible

 

 

 

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi rammy ,

     

    Have you configured based on the steps in the above document?

     

    Then which authentication type are you using? Windows or Database?

     

    Please ensure the credential you use to connect can access to your database.

     

     

     

    Best Regards,

    Icey

    • rammy's avatar
      rammy
      Helper I
      4 years ago

      Hi Icey 

      i have used database option to connect the sql server  from my power bi .but getting error that one i have mentiioned above .i am using ip,port and instance,port ,servername ,port  ,host nmae, port but connection is not established.

      NOTE : do i need to ping server ip to my pc is it require to establish connection

       

      please help me in this

      Thanks in Advance

      • Icey's avatar
        Icey
        Community Support
        4 years ago

        Hi rammy ,

         

         

        NOTE : do i need to ping server ip to my pc is it require to establish connection

         

        Please use ping to check if the connection is open. 

         

        If the connection is open, please right click on server instance and check server properties in that click Connection and see if Allow Remote Connection is enabled.

         

        If the connection is not open, and in order to help you solve the problem more quickly, please find professional network support. Thank you for your support and understanding.

         

         

        Best Regards,

        Icey

         

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