1. Install jruby (you may also need the package with JRE if is not already on your machine): http://jruby.org/download 2. Install the sequel gem: gem install sequel 3. Download the jdbc driver for SQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 4. Copy the sqljdbc4.jar in step 3's download into your apps directory (your app with require this later) 5. Copy the correct (32 bit or 64 bit) sqljdbc_auth.dll in step 3's download into your windows system32 folder 6. See demo.rb below for example of use.