HWilkinson asked a question.
"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 )
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]- 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.
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
192.168.0.1