Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Please help me in Data Gateway Connection.

Scenario - 
I have fetched data using SQL Server and also VPN IS Enable. 
I have follow all step by syep procedure.
1. Create gateway. 

2. Filled Connection Name.

3. Connection Type: SQL Server
4. Server : (with : port number)

5. DataBase Name.

6. Then Authentication 
 a. Authentication  Method (Basic)

 b.  Username and Password ( Tried both Credentials - VPN & Server 

7. In Privacey Level - Orgnisation 


still got below error 

suparnababu8  
INTURI_SUPARNA_ 

8 Replies

  • Hi Anonymous 

     

    Because you are using a VPN, you will need to install a power BI standard gateway and then configure the connection to gateway on your gateway is where you will install the VPN to connect your database server. Unfortunately there is no other way to get this done successfully. Install an on-premises data gateway | Microsoft Learn

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello Sir

      I have used Same as you reply - standard gateway. Even unable to get connected.

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi Anonymous  ,

    I could see that error you are getting is related to failed connection with SQL Server.
    The error, "error 25- Connection string is not valid" indicates that its  preventing the database client from establishing a valid connection to the server.
    1. Check if you are using the correct string to connect.
    2.Just use the instance name and do not use the HOST NAME 

    Ref- error 25- Connection string is not valid

    Please do check out this too -
    Unable to connect to SQL DB server (error 25)

    I hope this helps!
    If the response has addressed your query, please Accept it as a solution so other members can easily find it.
    Thank You!

  • Anonymous's avatar
    Anonymous
    Not applicable

    now credentials get okey. But not not able to add gate way. Got below error

    #not configured correctly

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi @Mukund1234 ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi @Mukund1234 ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You