Windows Server 2008 x64: Could not load file or assembly Microsoft.SqlServer.BatchParser...
The best minds are not in government. If any were, business would hire them away. - Ronald Reagan
I was working with a partner on testing his MSI Installer for various operating systems, and on Windows Server 2008 x64 it was continuing to come up with this error:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)
I checked the signature of the local assembly in the installation folder against the one in the GAC, and they were identical. So, go figure, right?
It turns out that the solution is very simple: Unless you've installed the 64-bit verion of SQL Server 2005, you need to install the 64-bit version of SMO. It's not there by default.
If it is not installed ,you can download the 64 bit version from http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_XMO_x64.msi and try again after installing it.
After the 64-bit SMO installation, the product installed perfectly.