"SqlUpdate failed" error on fresh install of XProtect Corporate 2023 R3

Good day,

I am trying to do a fresh install of XProtect Corporate 2023 R3 on my Microsoft Windows Server 2022 Standard and the milestone installer is giving me the ‘Could not configure the server. see the log file for more information.’ error.

installer log file error

12/19/2023 4:31:49 AM Information Calling SetupDatabaseTask

12/19/2023 4:33:29 AM Information Last error: {0}

12/19/2023 4:33:29 AM Error An error occurred: ‘InstallationAdapterException: Could not configure the server. See the log file for more information. —> ServerConfiguratorFailedException: Error occured while configuring the server. See log file at [C:\ProgramData\Milestone\Installer\ConfiguratorI.log](file:C:/ProgramData/Milestone/Installer/ConfiguratorI.log) for more information. —> DbUpdateException: SqlUpdate failed!’. Error details: at VideoOS.Installer.ServerConfiguratorPlugin.ConfigurationTaskInstall.DoRun()

at VideoOS.SoftwareManager.Core.Task.Task.Start()

12/19/2023 4:33:29 AM Error An error occurred: ‘ServerConfiguratorFailedException: Error occured while configuring the server. See log file at [C:\ProgramData\Milestone\Installer\ConfiguratorI.log](file:C:/ProgramData/Milestone/Installer/ConfiguratorI.log) for more information. —> DbUpdateException: SqlUpdate failed!’. Error details: at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.ServerConfigure(IServerAdminLog logComponent, Int32 webSitePort, String configuratorLogPath, IKeyStorage keyStorage, Action registerManagementServer, ISqlConnectionManager managementServerSqlConnectionManager)

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.RunInstall(Boolean isHWMM, Boolean isFinalizedMode)

at VideoOS.Installer.ServerConfiguratorPlugin.ConfigurationTaskInstall.DoRun()

12/19/2023 4:33:29 AM Error An error occurred: ‘DbUpdateException: SqlUpdate failed!’. Error details: at VideoOS.Server.Admin.Tasks.SetupDatabaseTask.Install(IDatabaseConnectionInfo databaseConnectionInfoMs, IDatabaseConnectionInfo databaseConnectionInfoIdp, IDatabaseConnectionInfo databaseConnectionInfoIncidentManager, String scriptsPath, String product, String companyName, Version currentDbVersion, Boolean isExternallyManaged, Boolean shouldDeleteDatabases)

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.ServerConfigure(IServerAdminLog logComponent, Int32 webSitePort, String configuratorLogPath, IKeyStorage keyStorage, Action registerManagementServer, ISqlConnectionManager managementServerSqlConnectionManager)

12/19/2023 4:33:29 AM Error Install failed.VideoOS.Installer.Sequencer.ErrorHandling.InstallerSequencerException: Could not configure the server. See the log file for more information. —> VideoOS.Installer.ServerConfiguratorPlugin.ServerConfiguratorFailedException: Error occured while configuring the server. See log file at [C:\ProgramData\Milestone\Installer\ConfiguratorI.log](file:C:/ProgramData/Milestone/Installer/ConfiguratorI.log) for more information. —> VideoOS.Server.Admin.Tasks.DbUpdateException: SqlUpdate failed!

at VideoOS.Server.Admin.Tasks.SetupDatabaseTask.Install(IDatabaseConnectionInfo databaseConnectionInfoMs, IDatabaseConnectionInfo databaseConnectionInfoIdp, IDatabaseConnectionInfo databaseConnectionInfoIncidentManager, String scriptsPath, String product, String companyName, Version currentDbVersion, Boolean isExternallyManaged, Boolean shouldDeleteDatabases)

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.ServerConfigure(IServerAdminLog logComponent, Int32 webSitePort, String configuratorLogPath, IKeyStorage keyStorage, Action registerManagementServer, ISqlConnectionManager managementServerSqlConnectionManager)

— End of inner exception stack trace —

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.ServerConfigure(IServerAdminLog logComponent, Int32 webSitePort, String configuratorLogPath, IKeyStorage keyStorage, Action registerManagementServer, ISqlConnectionManager managementServerSqlConnectionManager)

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.RunInstall(Boolean isHWMM, Boolean isFinalizedMode)

at VideoOS.Installer.ServerConfiguratorPlugin.ConfigurationTaskInstall.DoRun()

— End of inner exception stack trace —

Server stack trace:

at VideoOS.Installer.Sequencer.SequenceManager.Install()

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)

at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)

at VideoOS.Installer.Sequencer.SequenceManager.BeginInstallDelegate.EndInvoke(IAsyncResult result)

at VideoOS.Installer.UI.WizardPageInstall.InstallationEnded(IAsyncResult ar)

12/19/2023 4:33:29 AM Information ReadOrCreateConfigurationData

12/19/2023 4:33:29 AM Information ReadOrUpgradeConfigurationData started..

ConfiguratiorI log file error

12/19/2023 12:33:29 ‘IM’ has been executed successfully

12/19/2023 12:33:29

12/19/2023 12:33:29 SqlUpdate failed!

12/19/2023 12:33:29 at VideoOS.Server.Admin.Tasks.SetupDatabaseTask.Install(IDatabaseConnectionInfo databaseConnectionInfoMs, IDatabaseConnectionInfo databaseConnectionInfoIdp, IDatabaseConnectionInfo databaseConnectionInfoIncidentManager, String scriptsPath, String product, String companyName, Version currentDbVersion, Boolean isExternallyManaged, Boolean shouldDeleteDatabases)

at VideoOS.Installer.ServerConfiguratorPlugin.ServerConfigurator.ServerConfigure(IServerAdminLog logComponent, Int32 webSitePort, String configuratorLogPath, IKeyStorage keyStorage, Action registerManagementServer, ISqlConnectionManager managementServerSqlConnectionManager)

I have previously installed XProtect Corporate 2022 R3 on this same server with no issues. I did a clean uninstall of the 2022 version using this guide and subsequently a fresh install of the 2023 R3 version and I encountered this issue. I tried uninstalling the 2023 R3 version (the components still get installed even with this error showing up) using the same guide and doing a fresh install again and I’m met with the same error. My SQL Server Express 2022 is up and running during these installations

Please let me know if you require any more details from my end to identify the issue with this installation. I have attached the 2 related log txt files as well. Your help is greatly appreciated, thank you very much!

As this is not related to software development with the MIP SDK, which is the focus of this forum, please ask again in the support community, you should get better help from the partners using the support community.

https://supportcommunity.milestonesys.com