aspnetdb.mdf problem after publish a website .

Question

0.00/5 (No votes)

See more:

Dears
-
finally after hard work , i designed and developed a website and it is working fine on my local server .

i have 2 databases ,one of them is the main database which i create it with sql server 2005 ,
the other one called [ aspnetdb.mdf ] which was implemented internally with VS2008
and it just for membership .

-
Now after i upload a website on a server using FTP , the website working fine but when i browse a page that using [aspnetdb.mdf] data base , the below Error appeared

"
An attempt to attach an auto-named database for file D:\ftp\folder 1 \Domain name \www\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
"

my web.config contain the connection string of the first DB only
-
how i solve this problem .
i try to google this topic but i reach nothing , kindly help me

thanks

Posted 15-Jul-12 12:19pm

Hercal

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)

bbirajdar · Answer 1 · 2012-07-16T02:29:00

Solution 1

Do not use the aspnetdb.mdf on the hosting server. You can generate the Membership tables inside your main database using the aspnet_regsql command line utility.

http://www.shiningstar.net/ASPNet_Articles/SqlMembershipProvider.aspx[^]

Posted 16-Jul-12 2:29am

bbirajdar

Rahul Rajat Singh · Answer 2 · 2012-07-16T02:35:00

ASPNETDB.mdf should not be used as membership database on production server.

You should configure your production database to handle the membership data. run aspnet_regsql command on visual studio command prompt and configure the required database.

Secondly,(If you still want to use this only) by default the ASPNETDB.mdf is being accessed using the windows authentication when we access it on development machines. when you put your code on production server this will not work because windows authentication must be disables and sqlserver authetication must be used. you can do that by changing the web.config file, specifically the ConnectionString of the database.