How to increase Connection time out in Sql server?
Connection time out can be defined in SQL server in two ways.
1) Connection timeout in Connection string property: which determines how long it should take to open a connection. It is affected by Network i.e. If network is slow. If a connection is opened the connection time out property is not longer used. Its is just used before opening a connection.
2) Connection timeout in Command object : It is used after opening a connection, when used with Command object’s property “CommandTimeout” it becomes effective. You can increase connection time here and its effective after opening a connection.
