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.


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...


Unknown 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

Anonymous said...
Not working for me

Unknown 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 me up please.

indomakmur said...

you can say that green health is the best because it is all organic’

Huongkv said...

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

Post a Comment