MobiControl installation failure

E
Elena
Eli Lilly Spain

Hi team,

I'm trying to install MobiControl on a new clean server (w2019).

The download file is "MobiControl1560Setup_1018_release". During the installation, I request to get SQL installed and enter the SA password.

However every time I get this error:

I have cleared the AppData\Local\Temp folder and check the logs... but I can't seem to find how to fix it.

The server is a new clean build (only .Net Core has been installed) and the actual SOTI installer seems unable to get access to the locally installed DB, created by SOTI.....:

2022-10-27 14:38:35.827:    DACPAC: Deploying DACPAC file...
2022-10-27 14:38:50.665:    DACPAC: DAC Message: Message SQL0: The dac history table will not be updated.
2022-10-27 14:39:05.438:    DACPAC: FAILURE: DACPAC has failed to deploy: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Data.Tools.Schema.Sql.Dac.ConnectionManager.<>c__DisplayClass1.<Create>b__0()
   at Microsoft.Data.Tools.Schema.Common.SqlClient.RetryPolicy.<>c__DisplayClass4.<ExecuteAction>b__3(RetryState retryState)
   at Microsoft.Data.Tools.Schema.Common.SqlClient.RetryPolicy.ExecuteAction[R](Func`2 func, Nullable`1 token)
   at Microsoft.Data.Tools.Schema.Common.SqlClient.RetryPolicy.ExecuteAction(Action`1 action, Nullable`1 token)
   at Microsoft.Data.Tools.Schema.Common.SqlClient.RetryPolicy.ExecuteAction(Action action, Nullable`1 token)
   at Microsoft.Data.Tools.Schema.Sql.Dac.ConnectionManager.Create(SqlConnectionFactory connectionFactory, Boolean cacheConnections)
   at Microsoft.Data.Tools.Schema.Sql.Dac.DacRegistrationManager.DacInstancesManager.GetDacRegistrationData(SqlConnectionFactory connectionFactory, String databaseName)
   at Microsoft.Data.Tools.Schema.Sql.Dac.DacRegistrationManager.StartDeploy()
   at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
   at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
   at Soti.MobiControl.Tools.DacpacInstaller.Program.Main(String[] args)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:-1,State:0,Class:20

Any ideas? Many thanks

3 years ago
SOTI MobiControl
ANSWERS
RC
Raymond Chan Diamond Contributor
3 years ago

From the error message, you seem to be upgrading an old implementation rather than installing a new implementation from scratch.

Were you actually installing a totally brand new (i.e. no existing detabase with some device already enrolled)  MobiControl implementation?  Or migrating an old (pre v15.6) implementation (with database of enrolled devices/deployed policies)  to a new v15.6 MobiControl instance hosted on a MS-Windows Server 2019 server? 

Did you run the MobiControl  installer using Windows Server administrator account?

E
Elena
3 years ago

Hi,

It's a totally brand new server. There is no previous SOTI installed nor SQL.

During the installation SQL installation option is available. If SQL is already there, it wouldn't show that option

The SOTI installer is the latest available "MobiControl1560Setup_1018_release" (not sure where to get a previous one to test with).

And yes, I'm running the installation as admin

S
SAMOD@SOTI
3 years ago

Thank you for your post,

As per the logs you provided, it seems that there is a connection issue during the upgrade.


2022-10-27 14:38:35.827:    DACPAC: Deploying DACPAC file...
2022-10-27 14:38:50.665:    DACPAC: DAC Message: Message SQL0: The dac history table will not be updated.
2022-10-27 14:39:05.438:    DACPAC: FAILURE: DACPAC has failed to deploy: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I am sharing some links from SOTI Help related to your MobiControl Version 15.6:


Please make sure that all the requirements are met before attempting the upgrade, and thank you for confirming that you must be running the installer as an admin.

These article may help you for the time being:





For further investigation, please raise a ticket to the Technical Support.

Thank you.

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |