I am attempting to connect to a remote MSSQL server to use an authentication server and I am finding myself lost on the best way to finish the implementation.
I have added a section for the MSSQL server in my database.yml file but from there I am not sure the best way to proceed. The original way that I learned how to do this was to create model that establishes a connecting to the remote server and use that as my go between using ActiveRecord.
I was told at some point this was not the best approach. I am curious what the proper way is.
Ideally the end result of this is that I covert this into a gem to be used with my other rails apps but I have never created a gem before. But first thing is first, implementing it correctly from within my app.
Any thoughts, feedback, or references would be greatly appreciated.