By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

EC2 SQL Server Global Acelerator disconnect

0

I have an EC2 instance with sql server. I also have GlobalAcelerator pointing to that instance.

If the accelerator works quickly, I can connect from anywhere else but after a few minutes it disconnects from the SQL server. That doesn't happen if I connect to the server without using acceleration.

How can I solve that ?

Topics
Networking & Content DeliveryDatabaseCompute
Tags
AWS Global AcceleratorMicrosoft SQL ServerAmazon EC2
Language
English
Richard
asked 7 months ago540 views
2 Answers
0
Accepted Answer

Hi, Global Accelerator has idle timeout which will close the connection if no data has been sent for a certain period.

https://docs.aws.amazon.com/global-accelerator/latest/dg/introduction-how-it-works.html#about-idle-timeout

Therefore, the solution is to send data (send some queries) to the server.

profile picture
HS
answered 7 months ago
0

Try to increase the timeout setting and check at SQL level itself if timeout setting is properly configured there

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-ver16

profile picture
Chirag Nayyar
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content