Wix4CreateDatabase_X86 — FAILS, Error 0x80040154 · REGDB_E_CLASSNOTREG · "failed to create database: BAMInvoiceDB"

[Rajagurunathan-M007]

Question

Question

1. We're encountering an unusual issue during the MSI upgrade process. Instead of executing the database upgrade path, the CreatedDatabase WiX custom action is being triggered, resulting in an error, even though the database already exists on the Azure SQL Instance.
   We've verified that both the Azure SQL Instance and the target database are accessible from the same server using SSMS, confirming that connectivity, authentication, and network access are functioning correctly.

2. Error: Wix4CreateDatabase_X86 — FAILS, Error 0x80040154 · REGDB_E_CLASSNOTREG · "failed to create database: BAMInvoiceDB"

Below is the actual error captured in MSI log file,

[11:46:54:494]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI1B11.tmp, Entrypoint: CreateDatabase
CreateDatabase:  Entering CreateDatabase in C:\Windows\Installer\MSI1B11.tmp, version 6.0.2.0
CreateDatabase:  Error 0x80040154: failed to create to database: 'BAMInvoiceDB', error: unknown error
MSI (s) (5C!8C) [11:47:00:213]: Product: BAMInvoice-- Error 26201. Error -2147221164: failed to create SQL database: BAMInvoiceDB, error detail: unknown error.

CustomAction Wix4CreateDatabase_X86 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 11:47:00: InstallFinalize. Return value 3.
MSI (s) (5C:34) [11:47:00:400]: Note: 1: 2265 2:  3: -2147287035 
MSI (s) (5C:34) [11:47:00:400]: User policy value 'DisableRollback' is 0
MSI (s) (5C:34) [11:47:00:400]: Machine policy value 'DisableRollback' is 0

3. We've followed the internet solution, as it suggests to install OLEDB in MSI installing server, but OLEDB and full installation of SSMS are already installed in that server. This also didn't resolve the issue.

Repro Steps

1. Install MSI with Azure Database (SQL Authentication with Username and password)
2. Try to upgrade the MSI, instead of Database upgrade - CreateDatabase WIX action is triggered

Note: This only occurs for Azure Database(with SQL Authentication)

Any Idea on how we can resolve this issue?

Open Source Maintenance Fee

• I (or an organization I'm a member of) pay the Open Source Maintenance Fee by sponsoring the wixtoolset project because I support the maintainers.