It’s incredibly frustrating that this still happens, but it turns out that if you have Visual Studio 2010 and SQL Server Express 2008 (or R2) on your machine, and you uninstall SQL Server Express 2008 and install SQL Server Express 2012 instead, you’ll get an error trying to load database projects in Visual Studio 2010: “Could not load file or assembly ‘Microsoft.SqlServer.Management.SqlParser’”.
Why can’t SQL Server 2012 install the stuff it knows Visual Studio requires? Fine, whatever.
The fix for this problem is the same as the last time I posted something like this:
- Locate your Visual Studio 2010 installation media.
- In the \WCU\DAC folder, you’ll find three MSIs: DACFramework_enu.msi, DACProjectSystemSetup_enu.msi, and TSqlLanguageService_enu.msi. Run and install each of them. (Possibly just the third one is required in this case. I’m not sure.)
- Reapply Visual Studio 2010 SP1.
You should be back to a working state.
7 thoughts on “Fixing “Could not load file or assembly ‘Microsoft.SqlServer.Management.SqlParser’””
Ouch… gotta love those update uninstall and reinstall sessions!
Thanks, I had this exact problem and I would never have been able to figure it out on my own.
Just happened to me and I was able to fix it just re installing the third one (TSqlLanguageService_enu.msi) Thank you very much!!!!! I am using SQL Server 2008 and VS 2010 BTW.
Thanks, works great.
with VS2010 and SSMS2012 just using TSqlLanguageService_enu.msi has appeared to work for me as well. Thanks!
Thanks, solved by running TSqlLanguageService_enu.msi
Great blog posst