database with the same name exists, or specified file cannot

Jyoti Jodha

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" />

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
or try this

https://stackoverflow.com/questions/3500829/sql-express-connection-string-mdf-file-location-relative-to-application-locatio
+1
Rafnas T P9y ago
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
+1
Hari Shinde9y ago
@Jyoti

used full path of database not use | DataDirectory | like this
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\abc\test.mdf;Integrated Security=SSPI" />
+1
Jyoti Jodha9y ago
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.
0
Jyoti Jodha9y ago
in my Project Error Show

An attempt to attach an auto-named database for file D:\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
0
Karthi Keyan9y ago
give the another path or change the filename and try with that.
+1
Jyoti Jodha9y ago
IN bin\Debug\test.mdf
no any file test.mdf
but error show same.....???
0
Akshay Phadke9y ago
Try to move your file in another location . I hope, that will solve the error
+1
Jyoti Jodha9y ago
After this Show Same Error...
@
Karthi Keyan
0
Karthi Keyan9y ago
@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.
0
Jyoti Jodha9y ago
Name of articles...???
0
Satyaprakash Samantaray9y ago
check my articles
-4

database with the same name exists, or specified file cannot

Jyoti Jodha

9y24.8kWindows Forms

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" />

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
or try this

https://stackoverflow.com/questions/3500829/sql-express-connection-string-mdf-file-location-relative-to-application-locatio
+1
Rafnas T P9y ago
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
+1
Hari Shinde9y ago
@Jyoti

used full path of database not use | DataDirectory | like this
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\abc\test.mdf;Integrated Security=SSPI" />
+1
Jyoti Jodha9y ago
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.
0
Jyoti Jodha9y ago
in my Project Error Show

An attempt to attach an auto-named database for file D:\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
0
Karthi Keyan9y ago
give the another path or change the filename and try with that.
+1
Jyoti Jodha9y ago
IN bin\Debug\test.mdf
no any file test.mdf
but error show same.....???
0
Akshay Phadke9y ago
Try to move your file in another location . I hope, that will solve the error
+1
Jyoti Jodha9y ago
After this Show Same Error...
@
Karthi Keyan
0
Karthi Keyan9y ago
@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.
0
Jyoti Jodha9y ago
Name of articles...???
0
Satyaprakash Samantaray9y ago
check my articles
-4

database with the same name exists, or specified file cannot

Karthi Keyan

database with the same name exists, or specified file cannot

Karthi Keyan