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,
However there is no option "Import and Export Settings" in SQL Server Management Studio.
So to Fix this error,
| 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,
- Open Registry Editor
- Navigate to the location HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell
- Edit the value of the Reg Key "VisualStudioLocation" to %USERPROFILE%\Documents\SQL Server Management Studio
- Close Registry Editor
Now when you open or close SQL Server Management Studio, You will not get the error.
13 comments:
Thanks, its working
Perfect! I also saw some other goodies in there that I wanted to change. Thanks for posting!
Cool It's working Thanks...
Perfect, this also works for me!
Thank you Very Much, It's working ;)
Thanks its help me
AWESOME!! Thank you....this has been driving me nuts for weeks.
Excellent..!!
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
http://stackoverflow.com/questions/27623262/sql-server-management-studio-error-saved-settings-file-cannot-be-found-virtual
Not working for me
Thank You
Thank you!
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