I am wondering if the following steps are "normal" when trying to execute a SP when connected to SQL Server 2008 on customer site (the reason I put "normal" in quotation marks is I don't experience this when using SSMS on local copy of SQL Server).
I connect to their SQL Server (via VPN and SQL Server Authentication). Then I want to attach a database so I open New Query window. As soon as I open it and start typing, I get the Connect window (I have not even clicked on Execute yet). But entering my user name and password in this Connect window does not work. That is, I get a rejection message. I am surprised that I even get this "second" Connect window when opening a new query window. Is this the way it should work?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham