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
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