I'm getting the same error
>>Can you tell us which version of FarCry you are installing?
Latest version. Downloaded 7.2.8
>>which “skeleton” project you selected to install
I chose barebones
>>check to see if the “skeleton” folder for the project you selected has an “install” folder...
It does indeed
I verified that the user account I linked up via CF admin has create table permission
Error looks like:
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'dbo.farUser'.
The error occurred in (snipped)/farcry/core/webtop/install/index.cfm: line 996
Which tracked down to the code, it's a simple update statement:
UPDATE #form.dbowner#farUser SET password = (etc etc)
Looking in the database, no tables seem to have been created.
edit: did some snooping. Found the SQL file that is supposed to create the farUser table. Ran it manually. MSSQL Error.
Column, parameter, or variable #7: Cannot find data type longtext
So it ends up I was selecting SQL 2012 as my server type, when we actually run 2008. Now I have a new problem.
If I change the "Database Server" dropdown to anything other than "Microsoft SQL 2012 or newer" it responds with:
Database Server Engine Mismatch
Your database server for this DSN does not appear to be MSSQL2012.