Fix SSMS Error - The automatically saved settings file ‘\\Settings\CurrentSettings-YYYY-MM-DD.vssettings’ cannot be found. | SansSQL

Monday, August 27, 2012

Fix SSMS Error - The automatically saved settings file ‘\\Settings\CurrentSettings-YYYY-MM-DD.vssettings’ cannot be found.

When you try to Open or Close SQL Server Management Studio after an upgrade or fresh installation of SQL Server 2008 R2 you might get the below error which states,
The automatically saved settings file '\\Settings\CurrentSettings-YYYY-MM-DD.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent  settings file for this session.


However there is no option "Import and Export Settings" in SQL Server Management Studio.
So to Fix this error,
  1. Open Registry Editor
  2. Navigate to the location HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell
  3. Edit the value of the Reg Key "VisualStudioLocation" to  %USERPROFILE%\Documents\SQL Server Management Studio
  4. Close Registry Editor
Now when you open or close SQL Server Management Studio, You will not get the error.

13 comments:

Anonymous said...

Thanks, its working

Anonymous said...

Perfect! I also saw some other goodies in there that I wanted to change. Thanks for posting!

Anonymous said...

Cool It's working Thanks...

Anonymous said...

Perfect, this also works for me!

Anonymous said...

Thank you Very Much, It's working ;)

Anonymous said...

Thanks its help me

Anonymous said...

AWESOME!! Thank you....this has been driving me nuts for weeks.

Anonymous said...

Excellent..!!

Huy Kon said...

Edit the value of the Reg Key "VisualStudioLocation" to %USERPROFILE%\Documents\SQL Server Management Studio
bước này làm như nào vậy mọi người

ios learner said...

http://stackoverflow.com/questions/27623262/sql-server-management-studio-error-saved-settings-file-cannot-be-found-virtual
Not working for me

Unknown said...

Thank You

John J @ Pac States said...

Thank you!

Unknown said...

after reaching the following location i am not able to find microsoft sql server
HKEY_CURRENT_USER\Software\Microsoft\ "microsoft sql server" file
how could i proceed...help me up please.

Post a Comment