This guide will discuss the “Fix MSSQL Connection timeout and timeout period expired”. MSSQL is a suite of database software published by Microsoft. It includes a relational database engine, which stores data in tables, columns, and rows. Please, see How to configure screen saver timeout in Windows, how to Fix EFI network timeout on VMware Workstation, and “Microsoft SQL Evaluation period has expired: How to upgrade SQL Server instance“.
As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. This may run either on the same computer or on another computer across a network.
Error 1: MSSQL Connection timeout
Cannot connect to the localhost, connection timed out.
Solution
Furthermore, increase the timeout error in the MS Management Studio connection settings from 30 to 120. Remember to turn this back again to the default after the first connection.
Fix the initial timeout connection and this can be changed afterward. Increased connection timeout to 120.
Please, see “Desktop Wallpaper and Screen Saver Management: Configure and apply Group Policy Objects on Windows Server“, and “The server could not be reached or validated: Timeout expired. The Time out expired prior to obtaining a connection from the pool“
Error 2
However, Cannot connect “An exciting connection was forcefully closed by the remote host Sql Exception with error number 10054
Please, see “Windows 10 and Windows 11 updates will now expire for better performance“, What you need to know about Microsoft Defender Antivirus, and how to set up the OOTBI Virtual Appliance on Proxmox VE.
Solution
Try to identify and understand your environment to resolve this issue. This error clearly shows that the problem is not the firewall or the remote connections but the login process.
This was not resolved because connection seems to work but the authentication method I tried to use is not supported by the database instances and therefore did not work. I was trying to connect using Domain Account and this was not supported.
Moreover, I hope you found this blog post on the Fix MSSQL Connection timeout and timeout period expired helpful. Please let me know in the comment section.
