Summary

Runtime error 27504 related to the CU7 and later (CU8) Microsoft updates applied to SQL server

Symptoms

Runtime error when invoking custom action with entrypoint: ISSQLQueryDatabases:

Error 27504 SQL version requirements not met <Server Name\instance>. This installation requires Microsoft SQL Server 11.00.<minor version> or later

Cause

The current or upgraded installation version of SQL Server returns additional information about the Hotfix KB or Cumulative Update (CU), and therefore InstallShield is unable to determine the product version.

Steps To Reproduce

Install or upgrade versions of SQL 2012.

Resolution

Change built executable to use the SERVERPROPERTY metadata function manually as below:

1. Open your InstallShield project.
2. Go to the Direct Editor and select the ISSQLDBMetaData table.
3. Find the MSSQLServer entry.
4. Change the value of the VersionInfoCmd column to SELECT SERVERPROPERTY('ProductVersion')
5. Remove the value from the VersionBeginToken and VersionEndToken column.
6. Save the changes and rebuild your project

Additional Information

This issue is being tracked internally as work order: IOJ-1741080

Community Thread: "Error 27504" when installing against SQL 2012 SP2