tag:blogger.com,1999:blog-36098125361434986892024-10-03T03:59:15.237-07:00My Dreamshttp://www.blogger.com/profile/01578372294880950361noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3609812536143498689.post-43839271533169542802012-06-13T09:17:00.001-07:002012-08-11T10:21:21.312-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> <br /> <h3 class="post-title entry-title" style="border: 0px; color: #003964; font-family: Georgia, Times, 'Times New Roman'; font-size: 1.5em; font-weight: normal; line-height: 22px; margin: 0px 0px 8px; padding: 0px; vertical-align: baseline;"> <a href="http://www.aspdotnet-suresh.com/2012/08/iis-cannot-open-database-requested-by.html" style="border: 0px; color: #83390d; font-family: inherit; font-size: 23px; font-style: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">Asp.net-cannot open database requested by the login. the login failed. login failed for user 'iis apppool\DefaultAppPool'</a></h3> <br /> <b style="background-color: #f6f4ef; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px;"><u><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></u></b> <b style="background-color: #f6f4ef; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px;"><u><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Introduction:</span></u></b><br /> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">In this article I will explain how to solve&nbsp;</span><b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool'&nbsp;</span></b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">problem in IIS7.&nbsp;</span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px; margin: 0px; padding: 0px; vertical-align: baseline;"> <br /></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <b><u><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Description:&nbsp;</span></u></b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /><br />Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error. &nbsp;I did one sample application and&nbsp;<a href="http://www.aspdotnet-suresh.com/2010/09/publish-or-deploy-website-in-our-local.html" style="border: 0px; color: #d1580d; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;" target="_blank">deploy application</a>&nbsp;in IIS. I started running my deployed application at that time I get error like this&nbsp;</span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool'</span></b></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /><a href="" name="more" style="border: 0px; color: #d1580d; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; text-decoration: underline; vertical-align: baseline;"></a></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">To solve this problem I made modifications in IIS configuration to make those changes just follow below steps to solve this problem.</span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Start</span></b><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">&nbsp;---&gt;</span><span style="border: 0px; font-family: Wingdings; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">&nbsp;Open&nbsp;<b>Run</b>&nbsp;and type&nbsp;<b>inetmgr&nbsp;</b>and click OK now our&nbsp;<b>IIS&nbsp;</b>will open</span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">In IIS select&nbsp;<b>Application Pools</b>&nbsp;---&gt;</span><span style="border: 0px; font-family: Wingdings; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">&nbsp;In that select&nbsp;<b>DefaultAppPool&nbsp;</b></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">---&gt;</span><span style="border: 0px; font-family: Wingdings; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">&nbsp;Right Click on&nbsp;<b>DefaultAppPool</b></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">---&gt;</span><span style="border: 0px; font-family: Wingdings; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">&nbsp;Select&nbsp;<b>Advanced Settings</b></span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <table border="1" cellpadding="0" class="MsoNormalTable" style="background-color: #f6f4ef; border-spacing: 0px; border: 1pt dashed rgb(165, 42, 42); color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px; margin: 0px 0px 0.5em; padding: 0px; text-align: left; vertical-align: middle; width: 708px;"><tbody style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0.75pt; vertical-align: middle;"><div class="separator" style="border: 0px; clear: both; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; text-align: center; vertical-align: baseline;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG5JM0Zy9dG8OeDWuvoerO8niF-cYxY4aIaMb0DE2OJVjDuOGRnfoVNH_Wxp2qdvRwD2FRze6MEDH6_0YQX76-iov_Q3CVRkaHWMC-xMAZwC-LJ-POaTvEIpC562MoM6kj3ZMmfBJIkew/s1600/Applicationfool.png" imageanchor="1" style="border: 0px; color: #d1580d; font-family: inherit; font-style: inherit; margin: 0px 1em; padding: 0px; vertical-align: baseline;"><img border="0" height="447" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG5JM0Zy9dG8OeDWuvoerO8niF-cYxY4aIaMb0DE2OJVjDuOGRnfoVNH_Wxp2qdvRwD2FRze6MEDH6_0YQX76-iov_Q3CVRkaHWMC-xMAZwC-LJ-POaTvEIpC562MoM6kj3ZMmfBJIkew/s640/Applicationfool.png" style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;" width="640" /></a></div> <div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: inherit; line-height: normal; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span></div> </td></tr> </tbody></table> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">After open&nbsp;<b>Advanced Settings</b>&nbsp;one window will open in that select&nbsp;<b>Identity</b>&nbsp;and change path selection for&nbsp;<b>Identity</b></span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <table border="1" cellpadding="0" class="MsoNormalTable" style="background-color: #f6f4ef; border-spacing: 0px; border: 1pt dashed rgb(165, 42, 42); color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px; margin: 0px 0px 0.5em; padding: 0px; text-align: left; vertical-align: middle; width: 708px;"><tbody style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0.75pt; vertical-align: middle;"><div class="separator" style="border: 0px; clear: both; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; text-align: center; vertical-align: baseline;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihuOXzAPFWVWmK4mCz0F_303HiAD6kxojibTmpSMWiYjehYQem0wiRbVo3jMkMYRtaiZaW4ek6ZXGdLNbwOF01vgE76A99HALNIAWWyoazpMO2djx5IcL6nB_HZeqpgFdIxCukeDMEor4/s1600/Advanced+Settings.jpg" imageanchor="1" style="border: 0px; color: #d1580d; font-family: inherit; font-style: inherit; margin: 0px 1em; padding: 0px; vertical-align: baseline;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihuOXzAPFWVWmK4mCz0F_303HiAD6kxojibTmpSMWiYjehYQem0wiRbVo3jMkMYRtaiZaW4ek6ZXGdLNbwOF01vgE76A99HALNIAWWyoazpMO2djx5IcL6nB_HZeqpgFdIxCukeDMEor4/s1600/Advanced+Settings.jpg" style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;" /></a></div> <div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: inherit; line-height: normal; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span></div> <div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: inherit; line-height: normal; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> </td></tr> </tbody></table> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Now change the Identity path selection from&nbsp;<b>ApplicationPoolIdentity</b>&nbsp;to&nbsp;<b>LocalSystem</b></span></div> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <br /></div> <table border="1" cellpadding="0" class="MsoNormalTable" style="background-color: #f6f4ef; border-spacing: 0px; border: 1pt dashed rgb(165, 42, 42); color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px; margin: 0px 0px 0.5em; padding: 0px; text-align: left; vertical-align: middle; width: 708px;"><tbody style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> <tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><td colspan="2" style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0.75pt; vertical-align: middle;"><div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: inherit; line-height: normal; margin: 0px 0px 0in; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span><span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"></span></div> </td></tr> <tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0.75pt; vertical-align: middle;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcdXzOm8fN8R6azLW3vVnLplBVWQlWz1aMR-2hZhyVB7BS6uQR-7n3fMCGeAhYN5BddqWbHBdnN3EDFWMppeRS6FIfDRaOJU6MYwpASh4cPyBfm77pCVZDZG_fDhSXZQPeuqcyXMuia4/s1600/LocalSystem.jpg" style="border: 0px; color: #d1580d; font-family: inherit; font-style: inherit; margin: 0px 1em; padding: 0px; vertical-align: baseline;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcdXzOm8fN8R6azLW3vVnLplBVWQlWz1aMR-2hZhyVB7BS6uQR-7n3fMCGeAhYN5BddqWbHBdnN3EDFWMppeRS6FIfDRaOJU6MYwpASh4cPyBfm77pCVZDZG_fDhSXZQPeuqcyXMuia4/s1600/LocalSystem.jpg" style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0px; vertical-align: baseline;" /></a></td><td style="border: none; font-family: inherit; font-style: inherit; margin: 0px; padding: 0in; vertical-align: middle;"><br /></td></tr> </tbody></table> <div class="MsoNormal" style="background-color: #f6f4ef; border: 0px; color: #222222; font-family: Georgia, Times, 'Times New Roman'; font-size: 14px; line-height: 20px; margin: 0px; padding: 0px; vertical-align: baseline;"> <span style="border: 0px; font-family: Verdana, sans-serif; font-size: 10pt; font-style: inherit; line-height: 14px; margin: 0px; padding: 0px; vertical-align: baseline;">Select Built-in account to&nbsp;<b>LocalSystem</b>&nbsp;click&nbsp;<b>OK&nbsp;</b>now your problem will solve and it will work for you.&nbsp;</span></div> </div>My Dreamshttp://www.blogger.com/profile/01578372294880950361noreply@blogger.com0