I am sure I must be missing something obvious but when I tried to use the gem in a Rails app after installing the gem I got this error:
no such file to load -- activerecord-sqlserver-adapter
It seems that lib/activerecord-sqlserver-adapter.rb is not in the .gemspec.