{"id":69,"date":"2009-10-18T08:26:18","date_gmt":"2009-10-18T13:56:18","guid":{"rendered":"http:\/\/www.arjarapu.com\/wordpress\/?p=69"},"modified":"2010-03-28T13:24:55","modified_gmt":"2010-03-28T18:54:55","slug":"login-failed-for-user-iis-apppooldefaultapppool-eksite-getsitevariables","status":"publish","type":"post","link":"http:\/\/www.arjarapu.com\/wordpress\/2009\/10\/login-failed-for-user-iis-apppooldefaultapppool-eksite-getsitevariables\/","title":{"rendered":"Login failed for user &#8216;IIS APPPOOL\\DefaultAppPool&#8217;.[EkSite->GetSiteVariables()]"},"content":{"rendered":"<p>As I have mentioned earlier, I started <a href=\"#\">playing<\/a> around with the Ektron 400 CMS.NET content management system. Soon after I installed starter kit websites, I got the below error.<br \/>\n<code><br \/>\nLogin failed for user 'IIS APPPOOL\\DefaultAppPool'.[EkSite->GetSiteVariables()]<br \/>\n<\/code><br \/>\nMy system configuration is Windows 7 x64, IIS 7, .NET 3.5, SQL 2008 (with NT Authentication) and Ektron 7.6.6. If you got that error, this one could be your fix. <!--more--><\/p>\n<p>Resolution:<\/p>\n<ul>\n<li>Open your Internet Information Services Manager. IIS 7 from &#8211; Control Panel\\System and Security\\Administrative Tools<\/li>\n<li>Select the website  and \/ or virtual directory that&#8217;s causing the above error. <\/li>\n<li>On right side under &#8216;Manage Application&#8217; click on Advanced Settings<\/li>\n<li>Make a note of &#8216;Application Pool&#8217; under &#8216;General&#8217; category. Mine was on &#8216;DefaultAppPool&#8217;<\/li>\n<li>Now, go to your list of &#8216;Application Pools&#8217; and note the Identity under which the .NET Worker process is running. For me it was &#8216;ApplicationPoolIdentity&#8217;\n<div id=\"attachment_71\" style=\"width: 612px\" class=\"wp-caption none\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-71\" src=\"http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools.png\" alt=\"Application Pools on IIS 7\" title=\"iis7_app_pools\" width=\"602\" height=\"279\" class=\"size-full wp-image-71\" srcset=\"http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools.png 602w, http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools-300x139.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><p id=\"caption-attachment-71\" class=\"wp-caption-text\">Application Pools on IIS 7<\/p><\/div>\n<\/li>\n<li>Since my application \/ web.config is configured to use the Integrated Security, it&#8217;s trying to use  &#8216;ApplicationPoolIdentity&#8217; to login to the SQL Server. <\/li>\n<li>Since I already configured &#8216;NT Authority\\Network Service&#8217; to have database permissions, I changed the Application Pool&#8217;s Identity to &#8216;NetworkSecurity&#8217; as show below\n<p><div id=\"attachment_74\" style=\"width: 456px\" class=\"wp-caption none\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-74\" src=\"http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools_identity.png\" alt=\"Application Pool&#039;s Identity\" title=\"iis7_app_pools_identity\" width=\"446\" height=\"529\" class=\"size-full wp-image-74\" srcset=\"http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools_identity.png 446w, http:\/\/www.arjarapu.com\/wordpress\/wp-content\/uploads\/2009\/10\/iis7_app_pools_identity-252x300.png 252w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><p id=\"caption-attachment-74\" class=\"wp-caption-text\">Application Pool's Identity<\/p><\/div>\n<\/li>\n<li>Also make sure that this &#8216;Application Pool&#8217; is operating using the &#8216;Integrated&#8217; Managed Pipeline or else you might get <a href='#'>this<\/a> error<\/li>\n<li>The security concerns with respect to accessing the database using Network Service account is beyond this topic. Should you need to use less privileged account, then use SQL Authentication on Ektron as detailed in <a href='#'>here<\/a><\/li>\n<\/ul>\n<p>&#8211; Shyam K. Arjarapu<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are using the &#8216;Integrated Security&#8217; for SQL login and got &#8220;Login failed for user &#8216;IIS APPPOOL\\DefaultAppPool&#8217;.[EkSite->GetSiteVariables()]&#8221; error then read more to find the solution.  <a href=\"http:\/\/www.arjarapu.com\/wordpress\/2009\/10\/login-failed-for-user-iis-apppooldefaultapppool-eksite-getsitevariables\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13,14],"tags":[18,36,19,16,17,20],"_links":{"self":[{"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/posts\/69"}],"collection":[{"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":18,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":167,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/posts\/69\/revisions\/167"}],"wp:attachment":[{"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.arjarapu.com\/wordpress\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}