{"action":"created","issue":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/288","repository_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds","labels_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/288/labels{/name}","comments_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/288/comments","events_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/288/events","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/288","id":161933644,"number":288,"title":" Connect Sql server in Ruby on rails #489 ","user":{"login":"luis77","id":9296647,"avatar_url":"https://avatars.githubusercontent.com/u/9296647?v=3","gravatar_id":"","url":"https://api.github.com/users/luis77","html_url":"https://github.com/luis77","followers_url":"https://api.github.com/users/luis77/followers","following_url":"https://api.github.com/users/luis77/following{/other_user}","gists_url":"https://api.github.com/users/luis77/gists{/gist_id}","starred_url":"https://api.github.com/users/luis77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luis77/subscriptions","organizations_url":"https://api.github.com/users/luis77/orgs","repos_url":"https://api.github.com/users/luis77/repos","events_url":"https://api.github.com/users/luis77/events{/privacy}","received_events_url":"https://api.github.com/users/luis77/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-06-23T14:15:16Z","updated_at":"2016-07-13T15:29:21Z","closed_at":null,"body":"\r\n\r\nI need to connect to a SQL Server database, I installed gem 'tiny_tds' gem 'activerecord-sqlserver-adapter' gem 'deprecated'\r\nmy yml file:\r\n\r\ndefault: &default\r\nadapter: sqlserver\r\nhost: basddatos.dyndns.org\r\nusername: zu\r\npassword: pass\r\npool: 5\r\ntimeout: 5000\r\n\r\ndevelopment:\r\n<<: *default\r\ndatabase: Basdatos_2016\r\n\r\nI get this error: TinyTds::Error Server name not found in configuration files WHY? thanks\r\n"},"comment":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/comments/232392186","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/288#issuecomment-232392186","issue_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/288","id":232392186,"user":{"login":"Karamorf","id":126193,"avatar_url":"https://avatars.githubusercontent.com/u/126193?v=3","gravatar_id":"","url":"https://api.github.com/users/Karamorf","html_url":"https://github.com/Karamorf","followers_url":"https://api.github.com/users/Karamorf/followers","following_url":"https://api.github.com/users/Karamorf/following{/other_user}","gists_url":"https://api.github.com/users/Karamorf/gists{/gist_id}","starred_url":"https://api.github.com/users/Karamorf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Karamorf/subscriptions","organizations_url":"https://api.github.com/users/Karamorf/orgs","repos_url":"https://api.github.com/users/Karamorf/repos","events_url":"https://api.github.com/users/Karamorf/events{/privacy}","received_events_url":"https://api.github.com/users/Karamorf/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T15:29:21Z","updated_at":"2016-07-13T15:29:21Z","body":"I think I ran into this same problem, however without the rails part. It seems to not work in tiny_tds versions 0.9.5.rc.3 and 1.0.4 however it did work in 0.7.0. This was the ruby I was running:\r\nruby -e \"require 'sequel'; db = Sequel.connect({host: '10.198.135.174', database: 'database',user: 'user',password: 'PASSWORD',adapter: 'tinytds',port: 1433, azure: true}); puts db[:some view].where(:uid => 'some_username').all\"\r\n\r\nThis is the output I'd get for the error:\r\n/home/user/.gem/ruby/2.3.0/gems/tiny_tds-0.9.5.rc.3/lib/tiny_tds/client.rb:43:in `connect': TinyTds::Error: Login failed for user 'idr_admin@10'. (Sequel::DatabaseConnectionError)\r\n\r\nOr with the domain name (when host was set to 'name.domain.com'):\r\n/home/user/repos/acts/.bundle/lib/ruby/2.3.0/gems/tiny_tds-0.9.5.rc.3/lib/tiny_tds/client.rb:43:in `connect': TinyTds::Error: Login failed for user 'idr_admin@name'. (Sequel::DatabaseConnectionError)\r\n\r\nLet me know if you'd like a full stack trace.\r\n\r\n"}}
{"actor":{"display_login":"Karamorf"}}