{"action":"created","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/10749","repository_url":"https://api.github.com/repos/yiisoft/yii2","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/10749/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/10749/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/10749/events","html_url":"https://github.com/yiisoft/yii2/issues/10749","id":131291414,"number":10749,"title":"SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1) (severity 9)","user":{"login":"dariaman","id":10812303,"avatar_url":"https://avatars.githubusercontent.com/u/10812303?v=3","gravatar_id":"","url":"https://api.github.com/users/dariaman","html_url":"https://github.com/dariaman","followers_url":"https://api.github.com/users/dariaman/followers","following_url":"https://api.github.com/users/dariaman/following{/other_user}","gists_url":"https://api.github.com/users/dariaman/gists{/gist_id}","starred_url":"https://api.github.com/users/dariaman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dariaman/subscriptions","organizations_url":"https://api.github.com/users/dariaman/orgs","repos_url":"https://api.github.com/users/dariaman/repos","events_url":"https://api.github.com/users/dariaman/events{/privacy}","received_events_url":"https://api.github.com/users/dariaman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-04T09:38:22Z","updated_at":"2016-02-04T09:43:33Z","closed_at":null,"body":"OS : centos7 64 bit\r\nDB : SQL Server 2014 64 bit\r\nserver : nginx 1.8\r\n\r\nI have problem to connect yii2 to sql server\r\nI just use module user-management standard of extension yii2, and I had try this project on windows well.\r\nmy db.php\r\n```\r\n'class' => 'yii\\db\\Connection',\r\n    'dsn' => 'dblib:server=192.168.200.200,1433;database=mydb;MultipleActiveResultSets=false',\r\n    'username' => 'sa',\r\n    'password' => 'mypassword',\r\n    'charset' => 'utf8',\r\n```\r\nPHP.ini\r\n```\r\nextension=mssql.so\r\nextension=pdo.so\r\n```\r\n/etc/freetds.conf\r\n```\r\n[MSSQL]\r\n        host = 192.168.200.200\r\n        port = 1433\r\n        database = mydb\r\n        tds version = 7.0\r\n```\r\n/etc/odbc.ini (I created this file manual, not from instalation)\r\n```\r\n[TS]\r\nDescription = \" database mydb\"\r\nDriver = ODBC Driver 13 for SQL Server\r\nServer = 192.168.200.200\r\nPort = 1433\r\nDatabase = mydb\r\n```\r\n/etc/odbcinst.ini\r\n```\r\n[ODBC Driver 13 for SQL Server]\r\nDescription=Microsoft ODBC Driver 13 for SQL Server\r\nDriver=/usr/local/lib64/libmsodbcsql-13.0.so.0.0\r\nThreading=1\r\nUsageCount=1\r\n```\r\n\r\nWhen I Login in web, \r\nSQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1) (severity 9)\r\nwhat should I do ?"},"comment":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/comments/179735185","html_url":"https://github.com/yiisoft/yii2/issues/10749#issuecomment-179735185","issue_url":"https://api.github.com/repos/yiisoft/yii2/issues/10749","id":179735185,"user":{"login":"dariaman","id":10812303,"avatar_url":"https://avatars.githubusercontent.com/u/10812303?v=3","gravatar_id":"","url":"https://api.github.com/users/dariaman","html_url":"https://github.com/dariaman","followers_url":"https://api.github.com/users/dariaman/followers","following_url":"https://api.github.com/users/dariaman/following{/other_user}","gists_url":"https://api.github.com/users/dariaman/gists{/gist_id}","starred_url":"https://api.github.com/users/dariaman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dariaman/subscriptions","organizations_url":"https://api.github.com/users/dariaman/orgs","repos_url":"https://api.github.com/users/dariaman/repos","events_url":"https://api.github.com/users/dariaman/events{/privacy}","received_events_url":"https://api.github.com/users/dariaman/received_events","type":"User","site_admin":false},"created_at":"2016-02-04T09:43:33Z","updated_at":"2016-02-04T09:43:33Z","body":"in terminal, not problem\r\n![untitled3](https://cloud.githubusercontent.com/assets/10812303/12811339/64ee5f96-cb5e-11e5-8d32-1a6f49911322.jpg)\r\n"}}