Step 1: Configure development environment for Ruby development

You will need to configure your development environment with the prerequisites in order to develop an application using the Ruby Driver for SQL Server.

The Ruby Driver uses the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required.


  1. Download Ruby Installer
    If your machine does not have Ruby, install it. For new ruby users, we recommend you use Ruby 2.2.X installers, which provide a stable language and an extensive list of packages (gems) that are compatible and updated. Go the Ruby download page and download the appropriate 2.1.x installer. For example if you are on a 64-bit machine, download the Ruby 2.1.6 (x64) installer.

  2. Install Ruby
    Once the installer is downloaded:
    a. Double-click the file to start the installer.
    b. Select your language, and agree to the terms.
    c. On the install settings screen, select the check boxes next to both Add Ruby executables to your PATH and associate .rb and .rbw files with this Ruby installation.

  3. Download Ruby DevKit
    Download DevKit from the RubyInstaller page

  4. Install Ruby DevKit
    After the download is finished:
    a. Double-click the file. You will be asked where to extract the files.
    b. Click the "..." button, and select "C:\DevKit". You will probably need to create this folder first by clicking "Make New Folder".
    c. Click "OK", and then "Extract", to extract the files.

  5. Open cmd.exe

  6. Initialize Ruby DevKit

> chdir C:\DevKit  
> ruby dk.rb init  
> ruby dk.rb install  
  1. Install TinyTDS gem
> gem inst tiny_tds

Ubuntu Linux

  1. Open terminal

  2. Install Ruby Version Manager (rvm) and prerequisites

> sudo apt-get --assume-yes update  
> command curl -sSL | gpg --import -  
> curl -L | bash -s stable  
> source ~/.rvm/scripts/rvm  
  1. Use rvm to install Ruby
    For example, install version 2.3.0 of Ruby:
> rvm install 2.3.0  
> rvm use 2.3.0 --default  
> ruby -v  

           Ensure that the output of the last command indicates you are running version 2.3.0.

  1. Install FreeTDS
> sudo apt-get --assume-yes install freetds-dev freetds-bin  
  1. Install TinyTDS
> gem install tiny_tds  


Note: macOS already has Ruby pre-installed, as the OS has a dependency.

  1. Open terminal

  2. Install Homebrew package manager

> ruby -e "$(curl -fsSL"  
  1. Install FreeTDS
> brew install FreeTDS  
  1. Install TinyTDS gem
> gem install tiny_tds