Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server 2008 Connect Login pulldown sizing

Posted on 2014-04-14
5
Medium Priority
?
327 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 36

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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

578 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