{"action":"created","issue":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/266","repository_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds","labels_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/266/labels{/name}","comments_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/266/comments","events_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/266/events","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/266","id":149178559,"number":266,"title":"TinyTds::Error (Adaptive Server connection failed)","user":{"login":"monteirobrena","id":184617,"avatar_url":"https://avatars.githubusercontent.com/u/184617?v=3","gravatar_id":"","url":"https://api.github.com/users/monteirobrena","html_url":"https://github.com/monteirobrena","followers_url":"https://api.github.com/users/monteirobrena/followers","following_url":"https://api.github.com/users/monteirobrena/following{/other_user}","gists_url":"https://api.github.com/users/monteirobrena/gists{/gist_id}","starred_url":"https://api.github.com/users/monteirobrena/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/monteirobrena/subscriptions","organizations_url":"https://api.github.com/users/monteirobrena/orgs","repos_url":"https://api.github.com/users/monteirobrena/repos","events_url":"https://api.github.com/users/monteirobrena/events{/privacy}","received_events_url":"https://api.github.com/users/monteirobrena/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-04-18T15:07:48Z","updated_at":"2016-04-19T06:03:15Z","closed_at":null,"body":"I'm trying to connect my Rails project in Ubuntu with my database SQL Server in Azure.\r\n\r\nIn my server, when I access my project folder and run `rails s` I can connect with my database and everything work fine. But, if I run my project with Puma and Nginx, I receive this error:\r\n\r\n`TinyTds::Error (Adaptive Server connection failed):`\r\n\r\nThis is my `config/database.yml`:\r\n\r\n```\r\nstaging:\r\n  adapter: sqlserver\r\n  host: db-project.database.windows.net\r\n  database: db-project\r\n  username: user@db-project\r\n  password: password\r\n  port: 1433\r\n  azure: true\r\n```\r\n\r\nThe same error occurred when I try make a deploy with Capistrano and run `rake db:migrate`.\r\n\r\nAny help? Thank you. "},"comment":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/comments/211742554","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/266#issuecomment-211742554","issue_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/266","id":211742554,"user":{"login":"monteirobrena","id":184617,"avatar_url":"https://avatars.githubusercontent.com/u/184617?v=3","gravatar_id":"","url":"https://api.github.com/users/monteirobrena","html_url":"https://github.com/monteirobrena","followers_url":"https://api.github.com/users/monteirobrena/followers","following_url":"https://api.github.com/users/monteirobrena/following{/other_user}","gists_url":"https://api.github.com/users/monteirobrena/gists{/gist_id}","starred_url":"https://api.github.com/users/monteirobrena/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/monteirobrena/subscriptions","organizations_url":"https://api.github.com/users/monteirobrena/orgs","repos_url":"https://api.github.com/users/monteirobrena/repos","events_url":"https://api.github.com/users/monteirobrena/events{/privacy}","received_events_url":"https://api.github.com/users/monteirobrena/received_events","type":"User","site_admin":false},"created_at":"2016-04-19T06:03:15Z","updated_at":"2016-04-19T06:03:15Z","body":"@metaskills thank you so much.\r\n\r\nI install FreeTDS:\r\n\r\n```\r\nwget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz\r\n\r\ntar -zxvf freetds-stable.tgz\r\n\r\ncd freetds-0.91/\r\n\r\n./configure --with-tdsver=8.0 --with-openssl=/usr/bin\r\n\r\nmake\r\n\r\nsudo make install\r\n```\r\n\r\nAnd now I can access my database:\r\n\r\n```\r\ntsql -C\r\n\r\nTDSVER=8.0 tsql -H mydb.database.windows.net -p 1433 -U myuser@mydb -P mypassword -D mydb\r\n```\r\n\r\nAnd everything works when I run and access with Puma, Nginx and Capistrano."}}