# Ruby on Rails | MS SQL Server 2005 | Configuration

**URL:** <https://www.ruby-forum.com/t/ruby-on-rails-ms-sql-server-2005-configuration/115536>\
**Category:** Rails\
**Created:** [September 26, 2007, 2:21am UTC](https://www.ruby-forum.com/t/ruby-on-rails-ms-sql-server-2005-configuration/115536 "2007-09-26T02:21:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![erstwhileiii](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/a9adbd/32.png) [@erstwhileiii](https://www.ruby-forum.com/u/erstwhileiii)\
**Post date:** [September 26, 2007, 2:21am UTC](https://www.ruby-forum.com/t/ruby-on-rails-ms-sql-server-2005-configuration/115536/1 "2007-09-26T02:21:48Z")

</div>

Request: Full description of mechanims required to intergrate current  
Ruby / Ruby on Rails with MS SQL Server 2005

Environment:

- Ruby 1.8.6-25  
(ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32])
- Rails 1.2.3
- ruby-dbi 0.1.1 (installed dbi,dbd\_ADO)
- OS: Windows XP Professional sp4
- MS SQL Server Express 2005 installed on local machine

Background:  
I have used various settings for the config.db to no avail. These have  
included (where sa / password ARE the credentials for the database  
referenced):

development:  
adapter: sqlserver  
database: event\_development  
username: sa  
password: password  
host: localhost  
mode: DBI:ADO  
provider: SQLNCLI

development:  
adapter: sqlserver  
database: event\_development  
username: sa  
password: password  
host: DBI:ADO:Provider=SQLNCLI;Data Source=localhost;Initial  
Catalog=event\_development;User Id=sa;Password=Marimba;

development:  
adapter: sqlserver  
database: event\_development  
username: sa  
password: password  
host: localhost

Any help will be appreciated.

Regards

---

<div class="post-metadata">

**Author:** ![erstwhileiii](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/a9adbd/32.png) [@erstwhileiii](https://www.ruby-forum.com/u/erstwhileiii)\
**Post date:** [September 26, 2007, 4:26am UTC](https://www.ruby-forum.com/t/ruby-on-rails-ms-sql-server-2005-configuration/115536/2 "2007-09-26T04:26:07Z")

</div>

If you have installed the DBI ado.rb file in the /ADO folder… then  
this is  
what you need.

development:  
adapter: sqlserver  
database: event\_development  
username: sa  
password: password  
host: localhost

What’s the specific error message you get?

---

<div class="post-metadata">

**Author:** ![erstwhileiii](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/a9adbd/32.png) [@erstwhileiii](https://www.ruby-forum.com/u/erstwhileiii)\
**Post date:** [September 26, 2007, 4:26am UTC](https://www.ruby-forum.com/t/ruby-on-rails-ms-sql-server-2005-configuration/115536/3 "2007-09-26T04:26:08Z")

</div>

Since I no longer use Windows for my day job, I’m not sure if I have a  
good  
database.yml for SQL Server 2005 documented anywhere. However, I’ll have  
a  
look and get back to you.

Craig