Hi All, 

            I'm not using this (App_Data) Special folder at all in my web application. There is no folder as such!!! Do i need to install this SP1 or any hotfix to my server or this is some other issue? Please help me out of this problem.

Do you use a provider such as MembershipProvider or ProfileProvider?

They default to that directory. Check your web.config for any references also.

Hi MatsL,

              I 'm using Profile but not sure if this Profile Provider. Below is a part of my web.config file that shows the profile properties I 'm using in my web application.

<profile enabled="true">

<add name="LoggedUsername" type="string" allowAnonymous="true"/>

<add name="Email" type="string" allowAnonymous="true"/>

</properties>

</profile>

That's what's causing it I think, it stores the profile data in a database in App_Data.

Don't you have that folder on your dev machine? There is btw a checkbox in the publish dialog to include files from App_Data.

Hi MatsL ,

               I don't know where it stores the profile data Coz i didn't find any folder with the name App_Data in my web application. S, I don't have folder in my dev machine at all.

                Then I published the application as per your suggesstion as to check the checkbox that includes files from App_Data. After deploying this published web site, I found there is new folder by this name (App_Data) added but is empty. I got a different error this time when executing the application. The error is: Unable to connect to the database.

Hope we are getting closer to the solution of this problem

Then where the heck is your database?

It must be configured to be somewhere else. What is your connectionstring called btw, is it LocalSqlServer? That's the name of the default connectionstring that the provider use. Perhaps the db on your local machine has some tables that aren't present on the production?

 Also, set trace="true" in the page directive on a page and put this in your page_load:
Trace.Write(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);

Then you should see what database he's connecting to.

Hi MatsL ,

              I tried publishing the web applicatio 2nd time (using the check box checked to include App_Data along with radio button that includes all the file and this time it created a App_Data folder along with a database (aspnetdb.mdb) inside it. Strange as why it didn't created the database when i published first

              I deployed the application this time with the App_Data folder along with the database and configured the LocalSqlServer to use sa account to connect to the database and not it is working fine . Thousands of thanks MatsL  and now I understand whatz going behind the scene.

              Also, I 'm having a different database for my application and therefore, for my web application to work, i need 2 databases???. Is there any way I can make it one.