Search code examples
c#sql-serversql-server-expresssmo

Where can I find a SQL Server Management Objects Collection for SQL Server Express?


I have written an application that works fine when run from Visual Studio 2017, and uses the following libraries:

  • Microsoft.SqlServer.Management.Common
  • Microsoft.SqlServer.Management.Smo

But when I try to run it stand alone, I get the following error:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

Which I traced down to missing SQL Server Management Objects collection for the SQL Server.

I need to know how to resolve this, or if it can be resolved for SQL Server Express. I noticed these packs are available for install for the purchased SQL Server versions, but have found nothing for Express.


Solution

  • You need to install SQLSysClrTypes.msi

    UPDATED LINK https://download.microsoft.com/download/1/3/0/13089488-91FC-4E22-AD68-5BE58BD5C014/ENU/x86/SQLSysClrTypes.msi

    ... and maybe reboot your S.O

    SQL = Structured Query Language ( sequel is just phonetics or a DB tool for Ruby )

    OLD LINK http://go.microsoft.com/fwlink/?LinkID=188392&clcid=0x409

    When you said "compiled executable", did you take the .exe, all .dll and all other files from bin folder? Please, copy entire content of your bin folder.