Redmine 3.0 problem with MSSQL 2008
Added by Alexey Markin over 9 years ago
Hello.
I'm trying to install Redmine 3.0 on Server 2003. Storage I'm going to use MSSQL 2008 R2.
Ruby: 2.0.0-p643
Rails: 4.2
When I run command:
rake db:migrate
I see:
== 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.
Replies (2)
RE: Redmine 3.0 problem with MSSQL 2008 - Added by Toshi MARUYAMA over 9 years ago
It seems MSSQL 2008 is unsupported.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/382#issuecomment-72066985
RE: Redmine 3.0 problem with MSSQL 2008 - Added by Alexey Markin over 9 years ago
Thank you for your answer.
Apparently, further efforts are useless.