Login failed in Deployed ASP.NET web application

[sangam56]

Hi all.
I have a web application developed in ASP.NET. I have my data file aspnetdb.mdf kept in App_Data folder. I have also created msi windows installer
and I also installed it. It is installed in the wwwroot folder of the Inetput. The login page is the default page and it is properly displayed in the browser.

But the login is failed. Should I do anything more before deploying the web site?
I am using sql server 2005 management studio express. I have not attached my database in the sql server 2005 management studio express. Should I?

Further, even if I detach the database from right clicking App_Data folder, and attach in the management studio, the database is displayed in the management studio with the full name like: C\Document and Settings\My Documents\Visua l studio 2005\Web sites\aspnetdb. mdf. And it is read only also.

I am very confused. And none of my tricks are working. Please help me. Thanks in advance.

[daonho]

Check to my sure the the connectionstrin g in web.config is correct. Usually, that is the most common problem during web deployment. What kind of error are you getting? If you can't see the error , add this tag between <system.web></system.web> in the web.config file

<customErrors mode="Off"/>

[sangam56]

I just get the message from login control that the login failed.
"Your login attempt was not successful. Please try again."

Further the connection string is like below:

<connectionStri ngs>

<add name="Connectio nString" connectionStrin g="Data Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\aspnetd b.mdf;Integrate d Security=True;U ser Instance=True"
providerName="S ystem.Data.SqlC lient" />

</connectionStrin gs>


I don't think there is problem in connection string. With the above connection I need not to attach the database in the SQL management studio express.

Any idea please.