Forum Discussion
Solved
Issue with Scheduled Refresh of SQL Server Connection-gatway
Hi All, I have a gateway installed on an AWS server. I have multiple connections to MySQL databases, and they work correctly. I recently created a new connection to a SQL Server database using the...
The issue is likely with your SQL Server connection string. When using named instances (\MSSQLSERVER2019), scheduled refreshes can fail even though manual refresh works.
Try using the full TCP connection details instead:
Server: xx000.webserver.xx,1433 (replace with actual port)
Or use the server's IP address with port
Update the data source in your gateway configuration with these TCP details.
Hi Giu
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.