Follow

Error: "Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo..."

Symptoms

You receive the following error:

Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo[...]

Cause

You have not installed the SQL Shared Management Objects (SMO). They are needed to create tables and other SQL objects from TX.

Resolution

Download the SQL Shared Management Objects from the SQL Server Feature Packages and install it. The download sites are linked below - the file you need is called SharedManagementObjects.msi.

Please be aware that if you are using another version of SQL server, you must find the right version of the feature packages.

Notes

If you are deploying to multiple versions of SQL Server, you must install all the relevant versions of SMO/XMO. For example, if staging is SQL 2008 and Data Warehouse is SQL 2012, you must install both of these files.

SQL Native Client is a pre-requisite and will in most cases need to be installed first.

In some cases, you will also need to install the Analysis Management Objects package to resolve this error.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.