{"id":18,"date":"2016-05-13T06:12:04","date_gmt":"2016-05-13T06:12:04","guid":{"rendered":"http:\/\/waynenguyen.org\/dev\/?p=18"},"modified":"2016-05-13T06:12:04","modified_gmt":"2016-05-13T06:12:04","slug":"cannot-connect-to-sql-db-from-iis-connection-works-from-iisexpress","status":"publish","type":"post","link":"https:\/\/bruceng.com\/dev\/?p=18","title":{"rendered":"Cannot connect to SQL DB from IIS, connection works from IISExpress"},"content":{"rendered":"<p>Stackoverflow question\/answer:\u00a0<a href=\"http:\/\/stackoverflow.com\/questions\/20723623\/application-cannot-open-sql-connection-when-on-iis\">http:\/\/stackoverflow.com\/questions\/20723623\/application-cannot-open-sql-connection-when-on-iis<\/a><\/p>\n<p>You can either give permission to the app pool from within SQL Server.<\/p>\n<p>Or create a SQL Server user\/pass, update the connection string to use User\/Pass instead of Integrated Security<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stackoverflow question\/answer:\u00a0http:\/\/stackoverflow.com\/questions\/20723623\/application-cannot-open-sql-connection-when-on-iis You can either give permission to the app pool from within SQL Server. Or create a SQL Server user\/pass, update the connection string to use User\/Pass instead of Integrated Security<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[2,9,10],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-problems","tag-asp-net","tag-iis","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":1,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":19,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions\/19"}],"wp:attachment":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}