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!

Advertisements
This entry was posted in SQL Server DBA Stuff and tagged , , , . Bookmark the permalink.

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

  1. Dave says:

    It helps!

  2. Mary says:

    works perfectly thanks

  3. Hassan says:

    not work for me

  4. Andre says:

    Didn´t work for me!

  5. sundar says:

    did work for me…
    replay

  6. WOW, easy thing, yet so difficult to find. Thank you so much.

  7. manish pal says:

    work for me

  8. Hitesh says:

    worked for me, however, before installation i have deleted all files and folder from Temp directory, but SQL were looking for directory of temp, there is /temp/1 directory, i recreated directory named 1 in temp folder.

  9. GSanta says:

    Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s