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 !!! 😛

Advertisements

Say something : I accept all the "Humer&Critic"

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s