Solved

SQL Server 2008 Connect Login pulldown sizing

Posted on 2014-04-14
5
305 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
  • 3
5 Comments
 
LVL 33

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Auditing with Temporal Tables 4 29
sql query Help 12 52
How to use odbc in vb to connect to ms sql 14 26
MS SQL Inner Join - Multiple Join Parameters 2 17
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now