• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

Sometimes SQL server instance is not connecting due to slow internet connection

Dear Experts,

   Sometime in my machine sql server instance is not connecting due to slow internet connection. Could you help to assist to resolve the issue?
sql-connectissue.jpg
0
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
  • 4
  • 3
1 Solution
 
SimonCommented:
Errm, the screenshot shows that the account is locked out? Are you illustrating the fact that your account has been locked out because authenication is failing due to slow internet connection, or something else?
0
 
Easwaran ParamasivamAuthor Commented:
No. If I connect from office no issue. If I work from home SOMETIMES I got the error (at that time the internet is slow).
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The account is locked out for sure. You missed the password 3 times and that's why SQL Server locked the account.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Easwaran ParamasivamAuthor Commented:
No. Now I able to connect without taking any action.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Must has set a lock duration so if the time configured passed it will unlock automatically.
0
 
Easwaran ParamasivamAuthor Commented:
Could you please suggest where to increase the lock duration? Any configuration is there? Kindly suggest.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can change the lock duration threshold in the server policies. Please check this article that shows how to do it.
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now