Redmine on Windows with MS SQLServer

Added by Joseph M over 10 years ago

Hello,

Is there information, tutorials or feedback on how to install Redmine on Windows (Windows Server 2008 R2 64bits) with an MS SQLServer database?

I found information on how to install Redmine on [Windows + MySQL] or on [Linux + SQLServer] but nothing on [Windows + SQLServer].

Thank you in advance,
Regards,
Joseph

Replies (8)

RE: Redmine on Windows with MS SQLServer - Added by Felix Schäfer over 10 years ago

Well, in the end rails is an ORM, so it wraps the DB and abstracts it away from redmine. See if you can find any info on getting rails to work with MS SQL on windows and you should be able to use MS SQL with redmine provided you configure the database.yml correctly. That being said, redmine is not actively tested on MS SQL, so you could be "more easily" subject to bugs than a classic installation, and would need to provide very detailed error descriptions if this happens for the devs to help you (none will have an MS SQL installation to reproduce problems on).

RE: Redmine on Windows with MS SQLServer - Added by Joseph M over 10 years ago

Dear Felix,

Thank you a lot for your clear and prompt answer.

So if follow both tutorials simultaneously :

http://www.redmine.org/wiki/redmine/HowTo_Install_Redmine_in_a_sub-URI_on_Windows_with_Apache#Setup-windows-services

and

http://www.aspdeveloper.net/tiki-index.php?page=IISRubyOnWindows

obviously, what I am trying to do should work?

Thank you,

Kind regards,
Joseph

RE: Redmine on Windows with MS SQLServer - Added by Felix Schäfer over 10 years ago

Well, the first describes connecting an apache to redmine under windows, the other one describe how to connect IIS to it, so it really depends what webserver you use or want to use.

For the database connection to MSSQL, it seems the activerecord-sqlserver-adapter is the way to go, so try it with that.

RE: Redmine on Windows with MS SQLServer - Added by Joseph M over 10 years ago

Dear Felix,

Thank you a lot for your help.

I followed several tutorials and managed to have something more or less working.

Following steps seem to have worked :

set RAILS_ENV=production
rake config/initializers/session_store.rb
rake db:migrate
rake redmine:load_default_data

And I saw the Redmine website at some point (before launching "rake redmine:load_default_data").

However, now when I launch the webserver (mongrel) and try to access Redmine's website, I get the following error :

ActiveRecord::SerializationTypeMismatch in WelcomeController#index
permissions was supposed to be a Array, but was a String
RAILS_ROOT: C:/webserver/railsapp/redmine

I attached an image of the error for more details. This issue seem to be related to this one : http://www.redmine.org/issues/3903

I hope someone can help.
Cheers,
Joseph

RE: Redmine on Windows with MS SQLServer - Added by Joseph M over 10 years ago

Sorry, here is the image of the error.

error.jpg (118 KB)

RE: Redmine on Windows with MS SQLServer - Added by Felix Schäfer over 10 years ago

Do you have all your ruby gems at the correct versions? What collation do you use on the database? Could you provide a dump of the contents of the "roles" table?

RE: Redmine on Windows with MS SQLServer - Added by Brian K over 10 years ago

Joseph, do you have a list or a link to the steps you took to get Redmine running with MSSQL? I haven't had any luck yet.

RE: Redmine on Windows with MS SQLServer - Added by Vitor Odenor Aquino da Silva over 8 years ago

Joseph,
I'm with same problem, you could solve?

(1-8/8)