Forum Discussion

hapeta's avatar
hapeta
New Member
7 years ago
Solved

Issure trying to connect SQL Server to data gateway

Hi   I'm trying to connect the installed gateway to an SQL server on the same subnet (two different machines). I can connect the SQL server with Management Studio from the gateway-PC, but if I try...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi hapeta,

     

    Can you connect to it from Desktop in the gateway machine? I would suggest you check out the credential. Can you share the connection parameter when you set up the gateway? You can mask some sensitive part. Maybe you try another credential for there is more than one credential type.

    Issure_trying_to_connect_SQL_Server_to_data_gateway

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi hapeta,

 

Can you connect to it from Desktop in the gateway machine? I would suggest you check out the credential. Can you share the connection parameter when you set up the gateway? You can mask some sensitive part. Maybe you try another credential for there is more than one credential type.

Issure_trying_to_connect_SQL_Server_to_data_gateway

 

 

Best Regards,

Dale

  • hapeta's avatar
    hapeta
    New Member
    7 years ago

    Hi Dale,

    it worked. My mistake was I wrote the named instance in the Database field.

    With the name of the database it worked.

    Thank you