SQL server connection time out

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.

Tags: ,

Comments are closed.