Redmine

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).

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

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.

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

Sorry, here is the image of the error.

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?

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.

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