Link to home
Start Free TrialLog in
Avatar of raymurphy
raymurphy

asked on

MS SQL Server 2012 - SSMS 2012 SUDDENLY NOT OPENING/WORKING

Have an installation of SQL Server 2012 Developer Edition on my development laptop (Windows 7) which has been installed for about 2 years, with several databases, and Reporting Services also installed - this installation is used daily, and was still able to connect using SSMS 2012 as recently as yesterday.

Today, after no changes to my development laptop, when I try to launch SSMS, I'm suddenly getting some unexpected error dialog boxes.

First error dialog states something like "VsDebugPresentationPackage, Version=10.0.0.0 didn't load correctly", then another error stating "Microsoft.SqlServer.Management.SqlStudio package did not load correctly", and then an error along the lines of "Failed to open connection dialog ..... Object reference not set to an instance of an object Microsoft.SqlServer.Management.SqlStudio".

I've established that I can still connect using SQLCMD, and also I can still various Reporting Services reports that run against databases on this installation of SQL Server 2012 so to all intents and purposes the actual databases and database engine are still working OK, it's just the SSMS connectivity that has stopped working, and I just can't see why.

I've tried reinstalling just the SSMS 2012 client tools, but that has not solved this error, so any suggestions on how to resolve this will be greatly appreciated (unfortunately, I haven't got my original SQL Server 2012 installation DVD onsite with me today).

Thanks

Ray
SOLUTION
Avatar of Jerry_Justice
Jerry_Justice

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of raymurphy
raymurphy

ASKER

Thanks for following up, Jerry, no updates loaded and running SSMS as admins give same error ..
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry for the delay in getting back.

Installing SQL2012 SP2 did not make any difference.

Another related problem was that VS 2010 was also giving the same 'VsDebugPresentationPackage, Version=10.0.0.0 didn't load correctly' error. After looking round various VS 2010 forums elsewhere, saw that there didn't seem to be one definitive fix for this issue, and various forums presented a multitude of possible fixes.

In the end have gone for the brute force approach and removed .Net Framework V4 , then VS 2010 then SQL 2012 from development laptop. Then reinstalled .Net Framework V4, followed by fresh installation of VS 2010 (then applied VS 2010 SP1) and then finally reinstalled SQL 2012.

After all that, everything is working OK again - not a very elegant fix, but seems to have done the trick ....