SQL Server Management Studio: Access Remote Database over VPN

Note: This is a copy of the following ORIGINAL LINK on howtogeek.com by an unknown author originally written on 7/31/2008.  I am only republishing this content on my blog because I feel this is a GREAT ARTICLE and I don't know how long it will remain published on the ORIGINAL LINK.


This article is not only great for managing the UserNames and Passwords in mapped drives but also for accessing a remote database with SQL Management Studio over a VPN!

---

Original Article

---

Create a Shortcut to the Stored User Names and Passwords Dialog in Windows

If you’ve ever saved a password when connecting to a website that requires authentication, for a remote desktop session or a mapped drive, you might have wondered where those passwords are saved. If you are a long time reader, you already know where, but you might be interested in how to create a shortcut directly to the dialog where you can manage those logons.
You can add this into your folder of useful shortcuts… sure, you might not use it every day, but it’s good to know how to do it.

Create the Shortcut
Right-click on the desktop and choose New \ Shortcut from the menu.

In the location box, enter in the following command, and then on the next page give the shortcut a helpful name.

rundll32.exe keymgr.dll, KRShowKeyMgr

Once you have the shortcut, you’ll want to right-click on it and choose Properties, then click the Change Icon button on the Shortcut tab.

If you change the textbox value to the following file, you can find the matching icon for the shortcut (adjusting if your Windows is installed elsewhere)

C:\Windows\System32\keymgr.dll

Now you should have a nice matching icon…

Which will open up the Stored User Names and Passwords dialog.

Note that you can also use this to backup and restore your saved passwords, and it should work in either Windows 7, Vista or XP.