Forum Discussion

LenAiz's avatar
LenAiz
Regular Visitor
8 years ago

Invalid connection credentials

I am trying to set up a scheduled refresh using an on premises gateway on a Windows Server 2012 R2. The Sql database is on another server running Windows Server 2008. The following occurs when I refe...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

LenAiz,

Are you able to connect to the SQL database using same user and credential from the machine that installing gateway? You can install SQL Server Management Studio(SSMS) in the gateway machine to test the connetcion.

Regards,
Lydia

  • LenAiz's avatar
    LenAiz
    Regular Visitor
    8 years ago

    Thank you for the prompt response. I installed the SQL Server Management Studio(SSMS) on the gateway machine and the database and tables were fully visible. But I am still having connectivity / refresh problems. I have included a number of screen shots below:

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      LenAiz,

      Please test network connectivity using the following PowerShell script. Also please post gateway log here. For more details about troubleshooting gateway, please review  this article.

      Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

      Regards,
      Lydia