SQLServer - [ Error: Value cannot be null. Parameter name: viewInfo ]

Error: Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

I came across this error on a test database server when I launched the SSMS. The version of SQL Server I was using was 2008 R2 SE. A dialog box with following message would prompt whenever I click on anything in the management studio.

Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

The problem appeared to be when accessing the contents of a settings file. The file had invalid entries. This file is CurrentSettings-<date>. The fix for this is as shown below:

1. On the server Go to start menu–>Your profile–>Documents–>SQL Server Management Studio–>Settings (this is the location of the file specified above)

2. Delete all files from this folder

3. Restart sqlserver services

4. Launch the SSMS and this error is gone. You will be able to expand all the folders and perform regular SSMS activities without this error.

Hope this helps!

Font : http://mssqlnuggets.wordpress.com/