SQL Server 2017: Feature Pack Missing File

Question

I use Visual Studio 2015 and Microsoft SQL Server 2017 for a ASP.NET MVC project.

I get an error when I try to connect to the database:

Could not load file or assembly. 'microsoft.sqlserver.management.sdk.sfc version=12.0.0.0. Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.

I tried the solution on this link: Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

I would try the solution for version 2017: https://www.microsoft.com/en-us/download/details.aspx?id=55992

But there is no data (SharedManagementObjects.msi) for Microsoft SQL Server 2017 Feature Pack.

user_11708707 · Answer

Beginning with SQL Server 2017, Shared Management Objects (SMO) are distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package.

https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-ver15

SQL Server 2017: Feature Pack Missing File

1 Answers