Solved

SQL Server 2008 Connect Login pulldown sizing

Posted on 2014-04-14
5
313 Views
Last Modified: 2014-04-19
I am trying to find out how to increase the number if servers in my connect window.
My XP version allows the last 7 servers to show in the pulldown (see attached) while my Win7 version seems to only allow the last 3 servers to show in the list.

Where or How do I increase the the number of remembered entries on the Win7 version?
SQL-Load-Window.jpg
0
Comment
Question by:williambhowardjr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 34

Expert Comment

by:ste5an
ID: 39999745
The number of servers depends on the servers recognized automatically and these ones where you already where logged into.
0
 

Author Comment

by:williambhowardjr
ID: 39999844
I've  logged into all 7 servers from both versions
0
 
LVL 6

Expert Comment

by:Dulton
ID: 39999968
See this post on how to "clear" this file which contains cached connections. It shows the location of this file.
http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/


I checked mine out on my Visa OS, it's just XML. Don't see why you can't add the connection strings in you want from your XP machine to the Win 7 xml file and they'll appear.
0
 

Accepted Solution

by:
williambhowardjr earned 0 total points
ID: 40000126
Well, I didn't have mru.dat on either of my computers, however, further googling on mru.dat led me to find this file which I DID have: %APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin.

I couldn't edit it, however, I just copied "SqlStudio.bin" from my XP computer to the Win7 computer and now it also lists all 7 servers.

Thanks for all the help pushing me in the right direction..
0
 

Author Closing Comment

by:williambhowardjr
ID: 40010168
While this answer solves *my* problem of getting all my servers to show up in the Win7 pulldown, it doesn't really address *how* someone can set the number of allowed items in the pulldown.

Also, it looks like  SSMS saves the connect info to "SqlStudio.bin", but I can't find any way to edit this file.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question