Redmine 3.0 problem with MSSQL 2008
I'm trying to install Redmine 3.0 on Server 2003. Storage I'm going to use MSSQL 2008 R2.
When I run command:
== 62 InsertBuiltinRoles: migrating =========================================== rake aborted! StandardError: An error has occurred, this and all later migrations canceled: TinyTds::Error: Incorrect syntax near 'OFFSET'.: EXEC sp_executesql N'SELECT 1 AS one FROM [roles] WHERE [roles].[name] = N''Non member'' COLLATE Latin1_Genera l_CS_AS_WS ORDER BY [roles].[id] ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY'C:/I netpub/redmine-3.0.0/db/migrate/062_insert_builtin_roles.rb:6:in `up' C:in `migrate' Tasks: TOP => db:migrate (See full trace by running task with --trace)
What could be the problem ?
P.S.: sorry for my english. I used google translate.
RE: Redmine 3.0 problem with MSSQL 2008 - Added by Toshi MARUYAMA over 7 years ago
It seems MSSQL 2008 is unsupported.
RE: Redmine 3.0 problem with MSSQL 2008 - Added by Alexey Markin over 7 years ago
Thank you for your answer.
Apparently, further efforts are useless.