Forum Discussion

Mukund1234's avatar
Mukund1234
Frequent Visitor
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

    • Mukund1234's avatar
      Mukund1234
      Frequent Visitor

      Hello Sir

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

  • v-sdhruv's avatar
    v-sdhruv
    Community Support

    Hi Mukund1234  ,

    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!

  • Mukund1234's avatar
    Mukund1234
    Frequent Visitor

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

    #not configured correctly

  • v-sdhruv's avatar
    v-sdhruv
    Community 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
    Community 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
    Community 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