If all you're using the MSSQL database for is a username and password, you ought to make the MySQL database the primary database. In database.yml, add configuration for your MSSQL server. It will look something like:
mssql_connection: adapter: sqlserver database: dbmydatabase host: sqlserver.domain.com username: user password: secret
Then, generate a model in your project and insert code akin to:
class LoginInfo < ActiveRecord::Base set_table_name "user_info" establish_connection :mssql_connection
def fetch_username # code to get username here end
def fetch_password # code to get password here end end
Then you should be able to call UserInfo.fetch_username from within your app and the username will be returned.
