To connect MS SQL Server with Ruby on Rails follow the below steps:
SQL Server (2005 or higher recommended)
Install the adapters and driver
[code]
gem install tiny_tds
gem install activerecord-sqlserver-adapter
[/code]
Ensure the activerecord adapter and db driver gems are defined in your Gemfile
[code]
gem ‘tiny_tds’
gem ‘activerecord-sqlserver-adapter’
[/code]