database with the same name exists, or specified file cannot

Question

I've got a problem connecting to my Database. I get this error

An attempt to attach an auto-named database for file D:\abc\abc\bin\Debug\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

my connection string :

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test.mdf;Integrated Security=SSPI" />

Rafnas T P · Accepted Answer

or try this   https://stackoverflow.com/questions/3500829/sql-express-connection-string-mdf-file-location-relative-to-application-locatio

Rafnas T P · Answer

this is because of the user does not have a permition to access test.mdf file, to give permition right click on your file select Properties, then give permitions and try again

Hari Shinde · Answer

@Jyoti    used full path of database not use | DataDirectory | like this   connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=D:\abc	est.mdf ;Integrated Security=SSPI" />

Karthi Keyan · Answer

give the another path or change the filename and try with that.

Akshay Phadke · Answer

Try to move your file in another location . I hope, that will solve the error

Jyoti Jodha · Answer

Hello friends   Show this Error Also..     Error 38
Unable to apply a change while debugging. Source file 'C:\Users\pc\AppData\Local\Temp\.NETFramework,Version=v4.5.AssemblyAttributes.cs' was reloaded. You must restart the debugging session.

Jyoti Jodha · Answer

in my Project Error Show   An attempt to attach an auto-named database for file D:	est.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Jyoti Jodha · Answer

IN bin\Debug	est.mdf no any file test.mdf but error show same.....???

Jyoti Jodha · Answer

After this Show Same Error... @ Karthi Keyan

Karthi Keyan · Answer

@jodha,   The test.mdf databse already exists in this path :   D: \abc \abc \bin\Debug   Delete or move that file into the anothe place. then run your s/w.