SQLExpress database file auto-creation error

Question

0.00/5 (No votes)

See more:

I uploaded database directly to App_Data folder then error changed. It started giving some connection error. Anybody please tell me how to work with ASPNETDB.mdf??? 1 thing i dont know database should create on server automatically? or I should upload created mdf file to the server?? This problem has stopped my work for last 3 days.

HI all,

whenever I am running my application i am getting following error. But on my local pc its running well. i dont know how to solve it. Anybody can please help me? The error is like this.. It is creating 1 mdf file in App_Data folder but on server its giving following error.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.

Thanks in advance.

Posted 16-May-10 0:25am

hiren soni

Updated 16-May-10 21:47pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-05-16T01:03:00

Solution 1

Looks like a detailed error message. What have you done to try to fix it, based on the advice it gives ? Does the user on the server have permission to create files ? Is the connection string correct on the server ?

Posted 16-May-10 1:03am

Christian Graus

Comments

hiren soni 16-May-10 8:12am

There is no problem with connection string or folder permission. Both is OK. But still when its trying to create ASPNETDB.mdf its giving error.

#realJSOP · Answer 2 · 2010-05-16T01:08:00

What part of that didn't you understand? It's telling you *exactly* what is required.

0) The web server account needs read/write access to the Applications folder if the App_Data folder doesn't already exist. Solution - create the App_Data folder in your project BEFORE you deploy it.

1) If the App_Data folder DOES exist, but the database file doesn't exist in the App_Data folder, the web server account needs read/write access to the App_Data folder so it can create the database. Solution - create the database in your project BEFORE deploying it.

2) At the very minimum, the web server account needs read access to the App_Data folder so it can detect if the database file exists.

3) Sql Server Express (or higher) must be installed on the web server machine.

4) The web server account must have a local user profile. They even cite the document you should read to create this (if it's not already done).

I'm assuming that items 2, 3 and 4 are not the issue, but given your lack of descriptive prowess regarding your problem, it's really hard to tell.