Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
1  
when you connect the first time after opening SSMS, are you saving the password for the connection? As long as the password is saved, or you are using integrated authentication, it should never ask you to connect. –  Max Vernon Aug 29 '12 at 14:50
    
@MaxVernon I'm saving the password. It doesn't help. So I gather this doesn't happen to you. –  ispiro Aug 29 '12 at 16:06
    
No. I just double-clicked a query, and it simply opened up the query window already connected to my most recently connected sql server. –  Max Vernon Aug 29 '12 at 16:15
    
@MaxVernon Thanks. So I guess there's some bug in my system then. Are you using SSMS 2012? –  ispiro Aug 29 '12 at 16:20
    
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
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.