Hello,

on the server there is a log file on the root c:\,  open it and see the details of the error.

thanks

Hi,

correct the File is under C:\DBInstall.log

Question from My Side.

What Version MobiControl are you try to Install?

What Server Version are you Using ? Windows Server 2016 / 2019 ?

Local SQL Server Express with the installer or did yu have installed a Version on the Server?

Hi,

thanks for the answer.

Mobi: 15.3

Server 2019

SQL Express Installation local

From the log I get the following

"2021-04-21 12:12:41.401:    DACPAC: FAILURE: DACPAC has failed to deploy: Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment cannot continue.
Error SQL72018: Permission could not be imported but one or more of these objects exist in your source.
 ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Errors occurred while modeling the target database.  Deployment can not continue.
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.ThrowIfErrors(String message, ErrorManager errors, Object category)
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointServer.OnLoad(ErrorManager errors, DeploymentEngineContext context)
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.PrepareModels()
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.InitializePlanGeneratator()
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateController(Action`1 msgHandler)
   bei Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, ErrorManager errorManager)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, ErrorManager errorManager)
   bei Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<>c__DisplayClass5.<CreatePlanInitializationOperation>b__1()
   bei Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
   bei Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<CreatePlanInitializationOperation>b__0(Object operation, CancellationToken token)
   bei Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
   bei Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
   bei Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
   bei Soti.MobiControl.Tools.DacpacInstaller.Program.Main(String[] args)
2021/04/21 12:12:43.636(0x00001948):     ERROR: DACPAC deployment failed with error -1
2021/04/22 08:43:22.546(0x00000f84):     EVENT: [FeatureToggles] Toggles '' are read from command line:
2021/04/22 13:03:49.746(0x00000790):     EVENT: [FeatureToggles] Toggles '' are read from command line: "

HI Benjamin,

did you try to Upgrade an existing MobiControl Installation?

Is the SQl Server 2016 Express installed?

Did you use the 15.3.1 installer ?

Hi Marcus,

I'm trying to "reinstall" Mobicontrol with another database I restored from a customer. SQL Express 2016 is installed.

I used the 15.3 installer, not the 15.3.1 installer.

Hi Benjamin, it could be a user/permissions issue.

Database Permissions

When installing SOTI MobiControl, you must be either a SysAdmin or a DbCreator with additional ALTER ANY LOGIN permissions. When upgrading SOTI MobiControl, you must also have ALTER DATABASE permissions.

When performing regular operations for SOTI MobiControl Main and Archive databases, the user must have the following permissions:

Db_datareader
Db_datawriter
Permission for execution of all procedures

If possible, use an SA account for authentication. SA user accounts contain the right set of permissions to guarantee the proper functionality of SOTI MobiControl services. These credentials are not stored by SOTI MobiControl so store them in a safe place that is available to your organization.

Ok,

can I just add an SA User to the customers database after restoring? So that the user has enough priviliges? As I don't have a user from the customer.

I guess yes.

All you need is a sa user so you can specify it in the installation wizard

Thank you,

will give it a try.

Hi Benjamin,

Could you try upgrading your SQL Server to the latest cumulative update?

Regards,

Hi,

it's already on the newest one.