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 :
- Click on File -> Connect Object Explorer
- This will make Login panel appears again.
- 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 !!! 😛