{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/1854","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/1854/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/1854/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/1854/events","html_url":"https://github.com/metabase/metabase/issues/1854","id":130092624,"number":1854,"title":"Trouble connecting to SQL Server","user":{"login":"iwozzy","id":4137844,"avatar_url":"https://avatars.githubusercontent.com/u/4137844?v=3","gravatar_id":"","url":"https://api.github.com/users/iwozzy","html_url":"https://github.com/iwozzy","followers_url":"https://api.github.com/users/iwozzy/followers","following_url":"https://api.github.com/users/iwozzy/following{/other_user}","gists_url":"https://api.github.com/users/iwozzy/gists{/gist_id}","starred_url":"https://api.github.com/users/iwozzy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iwozzy/subscriptions","organizations_url":"https://api.github.com/users/iwozzy/orgs","repos_url":"https://api.github.com/users/iwozzy/repos","events_url":"https://api.github.com/users/iwozzy/events{/privacy}","received_events_url":"https://api.github.com/users/iwozzy/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/metabase/metabase/labels/Database/SQLServer","name":"Database/SQLServer","color":"532E78"},{"url":"https://api.github.com/repos/metabase/metabase/labels/Error","name":"Error","color":"CC333F"}],"state":"open","locked":false,"assignee":{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false},"milestone":null,"comments":21,"created_at":"2016-01-31T06:41:25Z","updated_at":"2016-03-29T00:54:32Z","closed_at":null,"body":"I've been trying to connect to various SQL Server instances and I am yet to be successful. I'm trying to connect to my local instance, an Azure instance and our production instance (not Azure). For every attempt I get:\r\n\r\n`Failed to connect to database: Timed out after 5000 milliseconds`\r\n\r\nI know that it's finding the database because when I turn off the TCP/IP via SQL Server Configuration Manager on my local instance for example, I get this error:\r\n\r\n`Failed to connect to database: java.sql.SQLException: Network error IOException: Connection refused: connect`\r\n\r\nIs there a way to enable more logging?\r\nSomeone mentioned `.database.windows.net` in the `host`, is that something that I should do?\r\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/202648521","html_url":"https://github.com/metabase/metabase/issues/1854#issuecomment-202648521","issue_url":"https://api.github.com/repos/metabase/metabase/issues/1854","id":202648521,"user":{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false},"created_at":"2016-03-29T00:54:32Z","updated_at":"2016-03-29T00:54:32Z","body":"@mhartman4 @seedubyaache @davidsirr @jkirkland-cityoflewisville-com @mdaymond @IgalSc \r\n\r\nDo you have a firewall running that might be blocking the connection? As @LukeAbell mentioned he was able to resolve this issue by setting up port forwarding.\r\n\r\nAt any rate we're working on resolving this issue so any other information that might be helpful is greatly appreciated. "}}