{"action":"created","issue":{"url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/541","repository_url":"https://api.github.com/repos/userfrosting/UserFrosting","labels_url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/541/labels{/name}","comments_url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/541/comments","events_url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/541/events","html_url":"https://github.com/userfrosting/UserFrosting/issues/541","id":152603196,"number":541,"title":"T-SQL support for SQL Server","user":{"login":"xoorath","id":769014,"avatar_url":"https://avatars.githubusercontent.com/u/769014?v=3","gravatar_id":"","url":"https://api.github.com/users/xoorath","html_url":"https://github.com/xoorath","followers_url":"https://api.github.com/users/xoorath/followers","following_url":"https://api.github.com/users/xoorath/following{/other_user}","gists_url":"https://api.github.com/users/xoorath/gists{/gist_id}","starred_url":"https://api.github.com/users/xoorath/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xoorath/subscriptions","organizations_url":"https://api.github.com/users/xoorath/orgs","repos_url":"https://api.github.com/users/xoorath/repos","events_url":"https://api.github.com/users/xoorath/events{/privacy}","received_events_url":"https://api.github.com/users/xoorath/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/userfrosting/UserFrosting/labels/compatibility","name":"compatibility","color":"fbca04"},{"url":"https://api.github.com/repos/userfrosting/UserFrosting/labels/data%20model","name":"data model","color":"00FFFF"},{"url":"https://api.github.com/repos/userfrosting/UserFrosting/labels/installer","name":"installer","color":"507642"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-05-02T17:40:20Z","updated_at":"2016-05-03T19:01:32Z","closed_at":null,"body":"Hey,\r\n\r\nI'm investigating userfrosting for an upcoming project. We would like to use our azure SQL db but I'm not sure how to connect successfully from userfrosting.\r\n\r\nA connection would normally be made with the following:\r\n`$connection = new PDO( \"sqlsrv:server = tcp:$HOST,$PORT; Database = $DB\", $USER, $PASS);`\r\n\r\nBut I'm unsure how I can tell userfrosting to make a connection with sqlsrv, or include tcp and the port in the hostname? I guess for the tcp+port I would just set `db_host` to include tcp and the port? but I'm still not sure how I could configure userfrosting to use sqlsrv...\r\n\r\nAny ideas?"},"comment":{"url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/comments/216631668","html_url":"https://github.com/userfrosting/UserFrosting/issues/541#issuecomment-216631668","issue_url":"https://api.github.com/repos/userfrosting/UserFrosting/issues/541","id":216631668,"user":{"login":"alexweissman","id":5004534,"avatar_url":"https://avatars.githubusercontent.com/u/5004534?v=3","gravatar_id":"","url":"https://api.github.com/users/alexweissman","html_url":"https://github.com/alexweissman","followers_url":"https://api.github.com/users/alexweissman/followers","following_url":"https://api.github.com/users/alexweissman/following{/other_user}","gists_url":"https://api.github.com/users/alexweissman/gists{/gist_id}","starred_url":"https://api.github.com/users/alexweissman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexweissman/subscriptions","organizations_url":"https://api.github.com/users/alexweissman/orgs","repos_url":"https://api.github.com/users/alexweissman/repos","events_url":"https://api.github.com/users/alexweissman/events{/privacy}","received_events_url":"https://api.github.com/users/alexweissman/received_events","type":"User","site_admin":false},"created_at":"2016-05-03T19:01:32Z","updated_at":"2016-05-03T19:01:32Z","body":"Also, I'm gonna go ahead and leave this open as the canonical issue for a db-agnostic installer."}}