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

hapeta's avatar
hapeta
New Member
7 years ago

I forgot to mention that on the SQL server are two named instances:

one SQL Server 2014 that works with the data gateway and one SQL Server Express that gives me the error.

 

Any ideas?

 

Thank you