I have a SQL Server database file Database1.mdf
. Every time I want to add a New Component (does not matter if it's a table, a function or something else), I get this error
The File or Assenbly "Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=8845dcd8080cc91" or one of its dependencies not found. The system can not find the file specified.
I did install the SQLSysClrTypes.msi
and the SharedManagmentObjects.msi
.
Does anyone know what's wrong?
I'm using Visual Studio 2013 Ultimate (Trial)
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.
SQL Server 2012
SQL Server 2008 R2
SQL Server 2008
SQL Server 2005
SQL Server 2019 - SMO Objects are now available in a NuGet package
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 wil also need to install the Analysys Management Objects package to resolve this error.
I face this problem too. The problem was fixed by replace the same version of Microsoft.SqlServer.ConnectionInfo.dll in application and database. So Please make sure that you are using sql sever 2014(Version 12.0.0.0) and Microsoft.SqlServer.ConnectionInfo.dll version 12.0.0.0 too.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With