Saved for later reference

online repository of stuff I had to google for hours to figure out – and random snippets of code

Microsoft SQL Server Management Studio 2008 R2 error: Value cannot be null. Parameter name: viewInfo

Tags: , , ,

I had a strange error after updating/rebooting a server yesterday: Management Studio popped up with the error above when I tried connecting to a server, and several other messages when trying to run queries.

After some unhelpful hints from other forums, I found the real solution/problem hidden in a post: My TEMP/TMP folder(s) didn’t exist.

For some reason my variables were set to:

1
2
TEMP=C:\Users\[user]\AppData\Local\Temp\1
TMP=C:\Users\[user]\AppData\Local\Temp\1

After the update, this “1” folder didn’t exist anymore. I could fixed this by editing the environment variables (right click Computer, Properties, Advanced, Environment Variables) and rebooting (since I didn’t know how many applications were using the wrong temporary folders).

Share

Tags: , , ,

© 2009 Saved for later reference. All Rights Reserved.

This blog is powered by Wordpress and Magatheme by Bryan Helmig.