Sunday, May 17, 2009

Management Studio Error : "Object reference not set to an instance of an object. (SQLEditors)"

Recieved this error in SQL 2005 Management Studio on a server when trying to open some tables.

"Object reference not set to an instance of an object. (SQLEditors)"

The databases concerned are fine, and can be accessed remotely from Management Studio.
After a lot of googling, all anyone could come up with was to reinstall / repair SQL using the installation program.

The actual solution wasn't actually that bad however.
I attempted to re-apply service pack 3 , this time downloading it fully.
What had happened was that the SP3 download I allowed Windows Update to install had failed to apply SQL 2005 SP3 to SQL Client Compentents.

Therefore SP3 saw this was the only element it needed to install, did so, and Management Studio worked again!

No comments: