# how to connect to microsoft sql server 6.5

**URL:** <https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829>\
**Category:** rubyonrails-talk\
**Created:** [October 4, 2010, 9:11pm UTC](https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829 "2010-10-04T21:11:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prinx](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@prinx](https://discuss.rubyonrails.org/u/prinx)\
**Post date:** [October 4, 2010, 9:11pm UTC](https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829/1 "2010-10-04T21:11:31Z")

</div>

Hi all, i'm beginner in rails world...i try to connect my rails application on a db sql server 6.5 without success, ca you help me? i try odbc driver, jtds e activerecord-sqlserver-adapter but nothing... what are the right gems or the right sequence procedure?

thx Prinx

---

<div class="post-metadata">

**Author:** ![pepe1](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@pepe1](https://discuss.rubyonrails.org/u/pepe1)\
**Post date:** [October 5, 2010, 12:40pm UTC](https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829/2 "2010-10-05T12:40:52Z")

</div>

I only know about SQLServer 2005 and 2008, not 6.5. Anyway, here is a list of things I had to do to get a project working with 2005 using Ruby 1.8.6, Rails 2.3.5 and Mongrel as the web server. You might need to skip/change some of the steps. I hope it helps:

1. Install Ruby (1.8.6): [Download Ruby](http://www.ruby-lang.org/en/downloads/) 2. Install rubygems: &nbsp;&nbsp;a. [Download RubyGems | RubyGems.org | your community gem host](http://rubygems.org/pages/download) (zip version) &nbsp;&nbsp;b. Unpack to a directory and cd there &nbsp;&nbsp;c. ruby setup.rb 3. Install rails: gem install rails –v=2.3.5 4. Install mongrel: gem install mongrel 5. Install mongrel service: gem install mongrel\_service 6. Install SQL Server adapter: gem install activerecord-sqlserver- adapter 7. Install ODBC gem: gem install odbc-rails 8. Install authentication gem: gem install authlogic 9. Install encryption gem: gem install attr\_encrypted 10. Install SQL Server Management utility (from Microsoft) 11. Create SQL Server DB 12. Create login in SQL Server 13. Create DB user 14. Create DSN in Windows: a. Control Panel -\> Adminstrative Tasks -\> Data Sources (ODBC) b. Click on System DSN -\> Add c. Select type SQL Server &nbsp;&nbsp;i. Name: \*Give it a name\* &nbsp;&nbsp;ii. Description: \*Give it a description\* &nbsp;&nbsp;iii. Server: Server name (\*whatever name you can see in the SQL Server Management Utility\*) &nbsp;&nbsp;iv. Use SQL Authentication

---

<div class="post-metadata">

**Author:** ![pepe1](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@pepe1](https://discuss.rubyonrails.org/u/pepe1)\
**Post date:** [October 6, 2010, 12:51pm UTC](https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829/3 "2010-10-06T12:51:45Z")

</div>

Forgot to add database.yml configuration. Here it is:

your\_environment\_here: &nbsp;&nbsp;adapter: sqlserver &nbsp;&nbsp;mode: odbc &nbsp;&nbsp;dsn: your\_dsn\_name\_here &nbsp;&nbsp;username: your\_username\_here &nbsp;&nbsp;password: your\_password\_here

There is no need to use host or port parameter since we're using a DSN.

---

<div class="post-metadata">

**Author:** ![prinx](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@prinx](https://discuss.rubyonrails.org/u/prinx)\
**Post date:** [October 7, 2010, 6:05am UTC](https://discuss.rubyonrails.org/t/how-to-connect-to-microsoft-sql-server-6-5/54829/4 "2010-10-07T06:05:00Z")

</div>

Ok, i'll try yours advice, i hope to do it... I will let you know 🙂

Thank's Prinx
