Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2010-07-19 : 14:22:38
|
| It seems that once 2008 SSMS finds a login it likes, then that login is displayed, by default, on the login window whenever you open SSMS. It makes no difference if I change it and log in with another id. It didn't behave like this in SQL 2005. 2005 seemed to display on the login window the last id that logged in whenever you start up SSMS.Just me, or do you have that problem too? Got a fix?I have a lot of servers to manage. This drives me nuts. Well, maybeI was nuts already, but it does cause extra aggravation. |
|
|
SQLvariant
Starting Member
5 Posts |
Posted - 2010-08-15 : 12:07:41
|
| In my experience SSMS 2008 mostly does a lot of remembering the login that was used with the last server that I touched. We use mostly NT authentication in my shop so it doesn't really become an issue for me. One key thing to point out though is that the button all the way to the left on the toobar labled "New Query" has a Network Connection as part of the icon. If you click this button it tries to open the new query window based on whatever the server/login of the last thing you touched in SSMS was. I didn't get that at first. Someone had to explain to me that the icon just to the right (also under File>New>Database Engine Query) will open up a new query window and always prompt you for server/login info.For the few servers that I need to login to with SQL Authentication I just set these up in Registered Servers "Ctrl+Alt+G" in a seperate folder. I say seperate folder because I always already have them setup once with NT Autherntication so I put them in this folder witht the SQL credentials. From there I just double-click on them and then they show up in Object Explorer with the login that I had saved. Doing this makes it so that whenever I need to open a new query on a server with specific non-NT credentials I just go to Object Explorer and Select New Query.I'm not sure if I answered your question but I hope this helps.Aaron Nelson - @SQLvarianthttp://sqlvariant.com/wordpress/ |
 |
|
|
|
|
|
Default Login SQL 2008 SSMS