Do you change the connection timeout to 5 seconds?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
By default, the connection timeout is 15 seconds. When it comes to testing if a connection is valid or not, 15 seconds is a long time for the user to wait. You should change the connection timeout inside your connection strings to 5 seconds.
"Integrated Security=SSPI;Initial Catalog=SallyKnoxMedical;Data Source=TUNA"
❌ Figure: Figure: Bad Connection String
"Integrated Security=SSPI;Initial Catalog=SallyKnoxMedical;Data Source=TUNA;Connect Timeout=5"
✅ Figure: Figure: Good Connection String with a 5-second connection timeout