Link to home
Start Free TrialLog in
Avatar of rkulp
rkulpFlag for United States of America

asked on

Another Login failed for user 'IIS APPPOOL\DefaultAppPool' Type Problem

I am trying to publish a website to a server running Windows 7 Professional and IIS 7. The problem is logging in. I have looked at the other page on E-E with the title 'Login failed for user 'IIS APPPOOL\DefaultAppPool' and created a separate AppPool. I don't get the error any more but I also don't get the login to work. I also tried attaching  ASPNETDB.MDF to the SQLServer/Express database. This failed.

So, this novice needs some instruction on how to publish a website and get the correct connection string for ASPNETDB.MDF and what changes to make in Web.Config and on the server to make it work. I appreciate any help I can get.
SOLUTION
Avatar of pateljitu
pateljitu
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rkulp

ASKER

Thanks for your quick responce, patelitu.  I have tried that connection string and also using |DataDirectory| as the server. I don't get an error but the login still fails. In the IDE, the same username and password works fine.
I will be gone until the 28th so can't test any other suggestions until then, but I will try to login and view them.
Thanks again.
Avatar of rkulp

ASKER

Possibly the problem lies in the way VS2010 publishes the website. ASPNetDB.mdf cas copied over but the SQLServer Management Studio sees it with a name which is the full path on the development computer. I can attach the db but then it is read only. What is the correct way to install the db on the server? Is my only effective choice to rebuild it completely?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rkulp

ASKER

Thanks for your help. Since I actually got the solution from another posting, I felt I could not award all the points.
Excellent you could resolve the issue, thanks for the points though.

Good luck.