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.
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.