Error 27504 SQL version requirements not met. This installation requires Microsoft SQL Server 11.00.x or later

[#1]

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

[lincoba]

Servername\SQL2016. Error 27504. SQL version requirements not met

How might I translate this information given here to work for: OS Win 10 and SQL 2016. We use the software and are trying to make it function on our current setup.

It's good info and I believe with a little adaptation will work on our app. To date I've edited the version to 13 and changed the supported OS to Win 10 and SQL 2016. My ammendments haven't worked as yet. Unedited code shown here.

                                VALUE "Internal Build Number", "99584s"?>

<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">

<assemblyIdentity

    version="1.0.0.0"

    processorArchitecture="X86"

    name="InstallShield.Setup"

    type="win32"

/>

<description>InstallShield.Setup</description>

<dependency>

    <dependentAssembly>

        <assemblyIdentity

            type="win32"

            name="Microsoft.Windows.Common-Controls"

            version="6.0.0.0"

            processorArchitecture="X86"

            publicKeyToken="6595b64144ccf1df"

            language="*"

        />

    </dependentAssembly>

</dependency>

<trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">

                <security>

                                <requestedPrivileges>

                                                <requestedExecutionLevel

                                                                level="requireAdministrator"

                                                                uiAccess="false"/>

                                </requestedPrivileges>

                </security>

</trustInfo>

<compatibility xmlns="urn:schemas-microsoft-com:compatibility.v1">

                <application>

                                <supportedOS Id="{35138b9a-5d96-4fbd-8e2d-a2440225f93a}"/>

                                <supportedOS Id="{e2011457-1546-43c5-a5fe-008deee3d3f0}"/>

                </application>

</compatibility>

</assembly>