Skip to main content

How do I remove the cached username and password from SQL Management Studio?

You may have your reasons to want to remove the cached username and password from the SQL Management Studio e.g. before handing your laptop to someone else.

The step to remove will require deleting a file but differs depending on the version of SQL Management Studio you are using.

SQL Server Management Studio 2014
Delete C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

SQL Server Management Studio 2012
Delete C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

SQL Server Management Studio 2008
Delete C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

SQL Server Management Studio 2005
Delete C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

One good news is as of SQL Server Management Studio 2012, you may delete an entry by using the tool itself without the need to delete a file. To delete, you will need to click on the 'Server name' dropdown in the 'Connect to Server' dialog. Move your mouse or use your keyboard arrow key to highlight the server to remove followed by hitting on the 'Delete' key on your keyboard. This is so convenient!

Popular Posts

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

DBS Coin Deposit Machines

DBS Bank has installed quite a few Coin Deposit machines at various locations e.g. Woodlands Civic Centre, Bedok, Towner Rd, South Bridge Rd, etc. These machines even accept 1 cent coins. However, the use of these machines do incur charges.

Read on
100 pieces = 75 cents ($0.75) chargeIf you deposit before 2pm on a working day, you will only see it in your bank account by 8pm on the same dayIf you deposit after 2pm on a working day or on a non-working day, you will only see it in your bank account by 8pm on the next working dayCharges are waived for kids account Correction: Charges will still be debited from a kid's (less than 12 years old) account when doing coin deposit. To waive the charges, you are required to retain the receipts and bring them personally to a DBS/POSB counter for a refund. Yes, the Coin Deposit machines are not intelligent enough to determine if the designated account is a kid's account.Currently, DBS website does not have information on this new Coin Deposi…