I am trying to deploy a winforms app and it won't start when I run the Setup file. I have checked the log during the build of the setup project and it says that I need version 11 of:
MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER
I am currently running VS2017 and SQL Server Management Studio and SQL Express version 14. I have the Parser in version 13 and 14, but I still get the same issue as because for some reason it is looking for version 11, which I cannot install.
I have spent two days trying to fix and can't. I have installed various feature packs where possible, but I am totally stuck.
Build output:
1>------ Build started: Project: CSV Manager, Configuration: Debug Any CPU ------
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'Microsoft.SqlServer.ServiceBrokerEnum' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'Microsoft.SqlServer.SqlEnum' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'Microsoft.SqlServer.ConnectionInfo' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'Microsoft.SqlServer.Management.Sdk.Sfc' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'Microsoft.SqlServer.Smo' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'System.Diagnostics.EventLog' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'System.Security.AccessControl' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'System.Security.Permissions' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'System.Security.Principal.Windows' does not allow partially trusted callers.
1>C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(3867,5): warning MSB3177: Reference 'System.ServiceProcess.ServiceController' does not allow partially trusted callers.
1> CSV Manager -> C:\Users\D\Dropbox\VS Project\CSVGenerator\CSV Manager\CSV Manager\bin\Debug\CSV Manager.exe
------ Starting pre-build validation for project 'Mappi CSV Manager' ------
------ Starting pre-build validation for project 'Mappi CSV Manager' ------
WARNING: Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='11.0.0.0') of assembly 'Microsoft.SqlServer.Smo.dll'
WARNING: Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='11.0.0.0') of assembly 'Microsoft.SqlServer.Smo.dll'
WARNING: Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='11.0.0.0') of assembly 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll'
WARNING: Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='11.0.0.0') of assembly 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll'
------ Pre-build validation for project 'Mappi CSV Manager' completed ------
------ Pre-build validation for project 'Mappi CSV Manager' completed ------
2>------ Build started: Project: Mappi CSV Manager, Configuration: Debug ------
2>------ Build started: Project: Mappi CSV Manager, Configuration: Debug ------
Building file 'C:\Users\D\Dropbox\VS Project\CSVGenerator\CSV Manager\Mappi CSV Manager\Debug\Mappi CSV Manager.msi'...
Building file 'C:\Users\D\Dropbox\VS Project\CSVGenerator\CSV Manager\Mappi CSV Manager\Debug\Mappi CSV Manager.msi'...
Packaging file 'Microsoft.SqlServer.ServiceBrokerEnum.dll'...
Packaging file 'Microsoft.SqlServer.ServiceBrokerEnum.dll'...
Packaging file 'Microsoft.SqlServer.Smo.dll'...
Packaging file 'Microsoft.SqlServer.Smo.dll'...
Packaging file 'CSV Manager.exe'...
Packaging file 'CSV Manager.exe'...
Packaging file 'dbScript.sql'...
Packaging file 'dbScript.sql'...
Packaging file 'Microsoft.SqlServer.Diagnostics.STrace.dll'...
Packaging file 'Microsoft.SqlServer.Diagnostics.STrace.dll'...
Packaging file 'AnalysisServicesProject.ico'...
Packaging file 'AnalysisServicesProject.ico'...
Packaging file 'CSV Manager.exe.config'...
Packaging file 'CSV Manager.exe.config'...
Packaging file 'System.Security.AccessControl.dll'...
Packaging file 'System.Security.AccessControl.dll'...
Packaging file 'System.Security.Permissions.dll'...
Packaging file 'System.Security.Permissions.dll'...
Packaging file 'Microsoft.SqlServer.Management.Sdk.Sfc.dll'...
Packaging file 'Microsoft.SqlServer.Management.Sdk.Sfc.dll'...
Packaging file 'System.Security.Principal.Windows.dll'...
Packaging file 'System.Security.Principal.Windows.dll'...
Packaging file 'Microsoft.SqlServer.ConnectionInfo.dll'...
Packaging file 'Microsoft.SqlServer.ConnectionInfo.dll'...
Packaging file 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll'...
Packaging file 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll'...
Packaging file 'System.ServiceProcess.ServiceController.dll'...
Packaging file 'System.ServiceProcess.ServiceController.dll'...
Packaging file 'System.Diagnostics.EventLog.dll'...
Packaging file 'System.Diagnostics.EventLog.dll'...
Packaging file 'Microsoft.SqlServer.SqlEnum.dll'...
Packaging file 'Microsoft.SqlServer.SqlEnum.dll'...
Packaging file 'Microsoft.SqlServer.SqlClrProvider.dll'...
Packaging file 'Microsoft.SqlServer.SqlClrProvider.dll'...
Packaging file 'System.Net.Http.dll'...
Packaging file 'System.Net.Http.dll'...
Packaging file 'Microsoft.SqlServer.Dmf.dll'...
Packaging file 'Microsoft.SqlServer.Dmf.dll'...