Active Record with SQL Server

To drive Silverlight applications using Watir, and actually modifying/editing the database with ActiveRecord a number of gems need to be installed.

• gem install watir
• gem install rspec
• gem install rake
• gem install activerecord
• gem install rubyzip
• gem install activerecord-sqlserver-adapter --source=http://gems.rubyonrails.org

Also copy the ADO.rb file [1] and place it in the following dir:

X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb

We need to install the rubyzip gem so that the unzip/zip functionality could work.

Minor changes to the 'sa' user had to be made. For that goto the SQL Server Management Studio Express. Under Security -> Logins; right click and goto the properties of the 'sa' user.

Under status change Login to 'Enabled'. Save changes.

Goto Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration manager. Restart the SQL Server Express.

PS If you cannot login using the 'sa' credentials: Right click on the server (after logging in using Windows Authentication) Go to security -> change permission to mixed mode.