SOTI Pulse Logo

Installation issue (Sql Service 2016 Express installation crashes)

L
Lore_32
ELI LILLY ITALIA S.P.A.

We are installing Soti MobiControl console version 15.2 on a Windows2016 server. The installation crashes while trying to install SQL Server Express 2016. The error logged is "This version of the installer is no longer supported". I have already investigated a little bit about the issue. It looks like the problem is caused by the fact that the bundled version of SQL Server included in the MobiControll installer is the ServicePack2. In fact, I have tried to preventively install the ServicePack3 version and it looks like it works. The incompatibility, most likely, is related to the SP2 version of SQL Srver Express 2016 with one the latest Microsoft security patches. Actually, the Windows Server 2016 I'm using is updated to August2022 bundle.
Unfortunately, being a production environment, it's not possible to install any different version than Soti MC 15.2 and, of course, it's not possible to remove any of the patches that could cause the issue.

I have already opened a case to SOTI support and we're waiting for a feedback, but I was just wondering if anybody else faced the same issue and how it can be resolved. The easiest way would be to be able to temporarily disable the SQL Server support check at Windows level (by changing a reg key or by using a specific policy?), but any suggestion would be more than welcome and appreciated.

Thank you very much, best regards

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

Which version of MobiControl v15.2?   Why stick to this version/build if there is installation problem? 

Are your installing a new implementation, migrating an old server to a new hardware or upgrading your existing MobiControl server?

L
Lore_32
3 years ago

Hi Raymond, thanks a lot for your interest here.

1) version 15.2.4.1138

2) because we're using SOTI for pharmaceutical manufacturing environment, and changing or upgrading any component requires a lot of time in terms of evaluation, testing and documentation; as already specified, upgrading to a different mobicontrol version is not actually an option

3) we are installing mobicontrol on a brand new windows2016 server

Just wanted to add that I tried to install the latest 15.5 version of mobicontrol on a DEV server, and I have the very same error during installation.

Regards

MB
Marcus Breitenthaler
3 years ago

Hi Lore,

sounds more a Migration?

If it is a Migration i would recommand to get in touch with the Soti Professional Service.

Also as Raymond recommanded to Update to a newer Servoer OS & SQL Express Version.

What Devices are you using?

Windows CE/WM / Android / iOS ?

L
Lore_32
3 years ago

Hi Marcus,

thanks to you too for the interest in this.

No, it's not a migration. It's a first installation of MobiControl.

By the way, I tried to execute a first installation of 15.5 version on both Windows2016 and Windows2019 servers, but in both cases I have the very same issue when the installer tries to complete the installation of sql server express 2016. We use Android devices. But of course, installation of mobicontrol doesn't take place because it crashes in the middle.

MB
Marcus Breitenthaler
3 years ago

Hi Lore,

when you run the installer from the Version 15.5.2 it is installing on the Same Server an SQL Express Server.

When you have alreday installed an SQL Express server you must set the User with the Rgiht Permissions during running the installer. 

That the Setup is able to Create the DB and have the other needed permissions.

Other Question:

Can you check the LOG from the installer?

C:\DBInstall.log if there are entrys with an failure

Did you have like this Entry inside ?

ERROR: CMCDbAccess::CheckResult:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Second Check the Password Policy on the Server.

I had it after a new installation that the Policy has required 10 Digits ;) When it is lower as the Password Requirements then it is not able to install the SQl Server.

Download the Setup from Microsoft Site : Download Microsoft® SQL Server® 2019 Express from Official Microsoft Download Center Execute the Setup on the Server with the Password what you had coosen for the SA User and see what message do you get.

With that i found out that the Passwort Policy was changed in the Background ;)

Also when you have Android Devices with Android 10 or higher i do not remind in detail was a minimum Version required to manage them correctly.

L
Lore_32
3 years ago

I have this in dbinstall.log:

022/08/30 13:11:37.312(0x000027f0):     ERROR: SQL state: [-1] 08001
2022/08/30 13:11:37.328(0x000027f0):     ERROR: OLEDB error: [80004005, -1] SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. 
2022/08/30 13:11:37.343(0x000027f0):     ERROR: SQL state: [-1] 08001
2022/08/30 13:11:37.343(0x000027f0):     ERROR: Database connection broken
2022/08/30 13:11:37.359(0x000027f0):     ERROR: CMCDbAccess::CheckResult:Login timeout expired
2022/08/30 13:11:37.375(0x000027f0):     ERROR: CMCDbAccess::CheckResult:A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
2022/08/30 13:11:37.399(0x000027f0):     ERROR: CMCDbAccess::CheckResult:SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. 
2022/08/30 13:11:37.406(0x000027f0):     ERROR: CMCDbAccess::CheckResult:Login timeout expired
2022/08/30 13:11:37.406(0x000027f0):     ERROR: CMCDbAccess::CheckResult:A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
2022/08/30 13:11:37.422(0x000027f0):     ERROR: CMCDbAccess::CheckResult:SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. 

As already specified at the beginning, the problem is that the mobicontrol installation crashes when tries to install the sql server bundled in the mobicontrol installer. The only way to have mobicontrol installed is to preventively install sql server, because running the installer downloaded from MS, it automatically searches the latest supported version and so there's no problem.

I'm a bit surprised that it's no longer possible to install mobicontrol on a server if you don't preventively install sql server. However, I'm still waiting for a support feedback regarding the case I opened. Let's see what they suggest to do

L
Lore_32
3 years ago

Similar Discussions