Understanding Connection and Command Timeouts in SQL Server
There are two primary types of timeouts to consider when working with SQL Server databases:Connection Timeout: This specifies the maximum amount of time a program will wait to establish a connection with the SQL Server database engine