Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an MSSQL database on a remote server. SSMS 2012 asks me to connect every time I double click a query in "Solution Explorer" in my project despite all of them having the same connection. Also, when I open the project - it asks me for every query that's already "open".

Is it supposed to work like this? If so - Any way around this?

Another thing: When SSMS opens - it doesn't have the passwords there. When I double click a query - it does. Is it supposed to be like this?

(I asked a similar question, but had a mistake. Also, added some information here...)

share|improve this question
I've seen the multi-auth prompts when the queries are opened from a zip file as opposed to unzipped 1st. Sounds like that's probably not the case from what you've described, but thought I'd mention it. – Eric Higgins Aug 29 '12 at 18:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.