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.

15 comments:

  1. AnonymousJune 13, 2013 at 1:15 AM

    Thanks, its working

    ReplyDelete
  2. AnonymousOctober 11, 2013 at 2:57 AM

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

    ReplyDelete
  3. AnonymousOctober 17, 2013 at 11:48 PM

    Cool It's working Thanks...

    ReplyDelete
  4. AnonymousDecember 3, 2013 at 8:09 PM

    Perfect, this also works for me!

    ReplyDelete
  5. AnonymousDecember 12, 2013 at 3:20 PM

    Thank you Very Much, It's working ;)

    ReplyDelete
  6. AnonymousDecember 29, 2013 at 4:05 PM

    Thanks its help me

    ReplyDelete
  7. AnonymousMarch 21, 2014 at 11:21 PM

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

    ReplyDelete
  8. AnonymousMarch 31, 2014 at 12:08 PM

    Excellent..!!

    ReplyDelete
  9. UnknownJune 25, 2014 at 5:09 PM

    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

    ReplyDelete
  10. AnonymousDecember 29, 2014 at 6:42 PM

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

    ReplyDelete
  11. UnknownJuly 13, 2015 at 1:43 PM

    Thank You

    ReplyDelete
  12. UnknownMay 30, 2016 at 10:24 AM

    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.

    ReplyDelete
  13. indomakmurMay 2, 2020 at 4:22 PM

    you can say that green health is the best because it is all organic’ https://royalcbd.com/product/cbd-oil-2500mg/

    ReplyDelete
  14. HuongkvSeptember 6, 2021 at 9:28 AM

    Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế

    vé máy bay đi Mỹ bao nhiêu tiền

    các chuyến bay từ mỹ về việt nam

    có chuyến bay từ nhật về việt nam chưa

    chuyến bay từ frankfurt đến hà nội

    giá vé máy bay từ Vancouver về việt nam

    Lịch bay từ Hàn Quốc về Việt Nam tháng 7

    khách sạn cách ly

    vé máy bay cho chuyên gia nước ngoài

    ReplyDelete
  15. sachinOctober 28, 2024 at 2:49 PM

    Not working for me

    ReplyDelete