Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  SQL2008 R2 Express Connection issue

Author  Topic  Buda56 Starting Member 14 Posts Posted - 2011-02-27 : 04:44:44 Hi, I am getting the following connection error when trying to connect to my Express database, this worked prior to upgrading from SQL 2008 Express. Error connecting to database: An attempt to attach an auto-named database for file C:\Users\Peter Annandale\Documents\Visual Studio 2010\Projects\DVMSystemWinSqlite\DVMSystemWin\bin\Debug\Data\DVMSData1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. I have tried all the normal posted resolutions and none seem to fix the problem, the file exists in the specified location. I added seciurtiy to the directory to ensure SQLExpress user had rights to the directory and still no go. Can anyone please advise a solution. Regards.. Peter