This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- "Error 27504" when installing against SQL 2012 SP2
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2015
10:37 AM
"Error 27504" when installing against SQL 2012 SP2
During an install, I call the SQLRTTestConnection2 to make sure the user has entered valid SQL connection settings.
This method works against SQL 2012 SP1, but after an upgrade to SQL 2012 SP2 (including a hotfix), the call fails with "Error 27504. SQL version requirements not met: (local). This installation requires Microsoft SQL Server 9.00.1399 or later."
This issue was reported by one of our customers and I was able to replicate it on my pc - Windows 7 Professional SP1, 64-bit operating system. After the SQL upgrade, the SQL version was set to 11.0.5623
I've installed a demo version of Installshield 2015 this morning and upgraded one of my Installshield MSI projects. Unfortunately, the same error occured.
I eventually discovered what was causing this issue; my projects's "SQL Scripts" settings have a requirement defined againts "Microsoft SQL Server" of "SQL Server 2005 RTM (Release to Manufacturing)". If I remove this setting the setup runs without any issues.
I assume this error needs to be logged?
PS I've also added this thread under Installshield 2012 (https://community.flexerasoftware.com/showthread.php?219465-SQLRTTestConnection2-fails-against-SQL-2012-SP2-with-quot-Error-27504-quot)
This method works against SQL 2012 SP1, but after an upgrade to SQL 2012 SP2 (including a hotfix), the call fails with "Error 27504. SQL version requirements not met: (local). This installation requires Microsoft SQL Server 9.00.1399 or later."
This issue was reported by one of our customers and I was able to replicate it on my pc - Windows 7 Professional SP1, 64-bit operating system. After the SQL upgrade, the SQL version was set to 11.0.5623
I've installed a demo version of Installshield 2015 this morning and upgraded one of my Installshield MSI projects. Unfortunately, the same error occured.
I eventually discovered what was causing this issue; my projects's "SQL Scripts" settings have a requirement defined againts "Microsoft SQL Server" of "SQL Server 2005 RTM (Release to Manufacturing)". If I remove this setting the setup runs without any issues.
I assume this error needs to be logged?
PS I've also added this thread under Installshield 2012 (https://community.flexerasoftware.com/showthread.php?219465-SQLRTTestConnection2-fails-against-SQL-2012-SP2-with-quot-Error-27504-quot)
(6) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 12, 2015
01:30 PM
It turned out that the system and build information for the current installation of SQL Server returned by the @@version scalar function contains an additional information highlighted in red below, and therefore InstallShield is unable to determine the product version (11.0.5623.0) from the string correctly:
To get it workaround, you can change InstallShield to use the SERVERPROPERTY metadata function by following the steps below:
[LIST=1]
Open your InstallShield project.
Go to the Direct Editor and select the ISSQLDBMetaData table.
Find the MSSQLServer entry.
Change the value of the VersionInfoCmd column to SELECT SERVERPROPERTY('ProductVersion')
Remove the value from the VersionBeginToken and VersionEndToken column.
Save the changes and rebuild your project.
This issue has been filed under #IOJ-1741080 and it will be fixed in a future version of InstallShield. Thank you for reporting this.
Microsoft SQL Server 2012 (SP2-CU7) (KB3072100) - 11.0.5623.0 (Intel X86)
To get it workaround, you can change InstallShield to use the SERVERPROPERTY metadata function by following the steps below:
[LIST=1]
This issue has been filed under #IOJ-1741080 and it will be fixed in a future version of InstallShield. Thank you for reporting this.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 02, 2016
04:30 PM
Is there a hotfix available to fix this for IS 2015 SP1?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 24, 2016
06:03 PM
Are there any plans to fix this issue in existing versions of InstallShield? 2014? 2015? 2016?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 24, 2016
09:47 PM
This issue has been fixed in InstallShield 2016. In InstallShield 2015 SP1 and previous versions of InstallShield, you can get it workaround by following the steps posted earlier in this thread.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 29, 2018
07:21 AM
Hi team,
In our client's machine, while installing against sql 2014(version-12.0.5203.0), we encountered error -" 27504. sql version requirements not met:(local) this installation requires Microsoft sql server 9.00.2047 or later"
I tried to follow the workaround steps which is given in this discussion thread
Open the InstallShield project.
Go to the Direct Editor and select the ISSQLDBMetaData table.
But when i went to Direct Editor and select the ISSQLDBMetaData table, i dont find any MSSQLServer entry.
Please let me know what should be my next steps?
Thanks,
Mamatha
In our client's machine, while installing against sql 2014(version-12.0.5203.0), we encountered error -" 27504. sql version requirements not met:(local) this installation requires Microsoft sql server 9.00.2047 or later"
I tried to follow the workaround steps which is given in this discussion thread
Open the InstallShield project.
Go to the Direct Editor and select the ISSQLDBMetaData table.
But when i went to Direct Editor and select the ISSQLDBMetaData table, i dont find any MSSQLServer entry.
Please let me know what should be my next steps?
Thanks,
Mamatha
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 23, 2018
09:59 PM
InstallShield is unable to determine the product version from the string correctly.
192.168.0.1
192.168.0.1