error in openning sql database connection

Question

1.00/5 (1 vote)

See more:

i have two sql databases that are created in a same way and they are in the same path.
i can open one but in opening another one i got this error:

An attempt to attach an auto-named database for file xxx.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share
thank you for any advice.

Posted 15-Nov-14 5:17am

4L4K1

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)

OriginalGriff · Answer 1 · 2014-11-15T05:46:00

Solution 1

Check your login information. Very often, you get that message because the login ID you are using does not have sufficient permissions.

Posted 15-Nov-14 5:46am

OriginalGriff

Comments

4L4K1 15-Nov-14 11:52am

they have same connection string except database file name.

OriginalGriff 15-Nov-14 11:57am

Can you share the two connection strings? Just replace the password with "XXX" for security.

4L4K1 15-Nov-14 12:07pm

they are connection string in App.config file

connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\bin\Debug\db\dbBackup.mdf;Integrated Security=True;Connect Timeout=30" providername="System.Data.SqlClient"
connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\bin\Debug\db\db.mdf;Integrated Security=True;Connect Timeout=30" providername="System.Data.SqlClient"

4L4K1 15-Nov-14 12:12pm

I do not know about sql connection but it makes me crazy because i can open the connection to db.mdf but can not open the connection to dbBackup.mdf
they are in the same path . they are created in the same way. oh my god!

OriginalGriff 15-Nov-14 12:19pm

Have you checked the folder? Are there any other files called "dbBackup" or "db" in the data directory? Do the the original files exist?

4L4K1 15-Nov-14 12:35pm

i searched whole my computer . there is just one file by the name dbBackup.mdf
i can connect to both manually in "Server Explorer" windows in visual studio 2013

OriginalGriff 15-Nov-14 12:52pm

No, I meant any other files called "dbbackup.*"...

And check your for access permissions: SQL doesn't use your login user to access the file, it uses it's own.

4L4K1 15-Nov-14 21:50pm

thank you very much OriginalGriff.
you make me check around again . and helped me in solving problem.
thank you.

4L4K1 · Answer 2 · 2014-11-15T15:48:00

Solution 2

the problem was this :
mdf file was not included in project.(i fond it in Solution Explorer windows)
i used relative path (AttachDbFilename=|DataDirectory|...)in connection string and it makes problem.

Posted 15-Nov-14 15:48pm

4L4K1