Project

General

Profile

How to set up Redmine in Windows with MSSQL 2012

Added by jian huang almost 11 years ago

Hi,

It's really pain in the ass to install Redmine in Windows with MSSQL 2012.

Unfortunately, one of my colleagues introduces Redmine for us, and I have to install Redmine onto Windows server, with IIS and MSSQL 2008 R2.

Currently, I have to stop at "rake db:migrate". It says "rake aborted! missing :host option if no :dataserver given". Actually, I follow the step 3, and make database.yml change to

production:
adapter: sqlserver
database: redmine
username: redmine # should match the database user name
password: redminepassword # should match the login password

So, I wonder whether I need to add host, after I add "host: localhost" to database.yml, I get "rake aborted! Unable to connect: Adaptive Server is unavailable or does not exist."

It's my first time to use Redmine, and not good at Ruby stuff. Can someone help me? Many thanks.

zeiglar.


Replies (6)

RE: How to set up Redmine in Windows with MS SQL 2012 - Added by jian huang almost 11 years ago

I solved this problem.

The installation needs to update, I nearly have issues in each single step.

It's definitely not a good experience at the very beginning.

Er..., pain in the ass.

RE: How to set up Redmine in Windows with MSSQL 2012 - Added by jian huang almost 11 years ago

Er.....

I fail to log in as admin. Any clues?
Also, I register couple of accounts, and manual active them in MSSQL, and neither of them can be logged in.

Invalid user or password

Any helps are welcomed.

RE: How to set up Redmine in Windows with MSSQL 2012 - Added by arul baskar over 10 years ago

development:
adapter: sqlserver
dataserver: servername
host: 127.0.0.1
port: 1433
database: databasename
username: ****
password: *
**

    (1-6/6)