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).

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