Fixing “Could not load file or assembly ‘Microsoft.SqlServer.Management.SqlParser’”
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.