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.
LVL 1
rkulpAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rkulpConnect With a Mentor Author Commented:
The problem is solved by following the steps in http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_23144483.html?sfQueryTermInfo=1+10+30+aspnetdb.mdf+deploi

I had read this before but did not understand what the Aspnet_regsql.exe program would do for me.
0
 
pateljituConnect With a Mentor Commented:
What is your existing connection string, please try this sample:

<add name="SqlServer"
connectionString= "Server=SQL_SERVER_ADDRESS,1433;Database= DB_NAME;User=USERNAME;Password=PASSWORD;"
providerName="System.Data.SqlClient" />
0
 
rkulpAuthor Commented:
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.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
rkulpAuthor Commented:
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?
0
 
rkulpAuthor Commented:
Thanks for your help. Since I actually got the solution from another posting, I felt I could not award all the points.
0
 
pateljituCommented:
Excellent you could resolve the issue, thanks for the points though.

Good luck.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.