Monday, July 15

How To: Set Connection Timeout in SQL SERVER

If you have just started SQL SERVER and frustrated because its asking you for username/password everytime you execute a query or try to open a window for new query. Then a simple reason behind that is connection timeout of your SQL SERVER(i am using 2008).

How to: Set Connection Timeout in SQL SERVER
Microsoft SQL Server Connection Properties


Just follow these steps :
  1. Click on File -> Connect Object Explorer
  2. This will make Login panel appears again.
  3. Now Click on Connection Properties and set Connection Timeout to a bigger value(I set it here to 3600 seconds = 1 hour)

This will only make you free from this issue only. I hope you'll find other issues to surf web in some time !!! :P
Post a Comment