Cannot attach Database..

[sanju4kk]

I have designed the database in SQL Server Compact and when i try to run the application it showing the following

Cannot attach the file 'D:\Webs\Login Page\Login Page\App_Data\UserMaintenance.mdf' as database 'UserMaintenance'.

Please help me someone...

[jmcilhinney]

Do you actually mean SQL Server Express? SQL Server CE uses SDF files and doesn't use a server while SQL Server Express uses MDF files (just like the grown-up SQL Server) and does use a server.

[jmcilhinney]

Assuming that it is SQL Server Express, if you connect to that instance in Management Studio, do you see an already attached database named "UserMaintenance"?

[sanju4kk]

its the compact database which is coming along VS2012

[jmcilhinney]

I assume that you added the database directly to your project. Did you select a Local Database or a Service-based Database?

[sanju4kk]

Local Database

[jmcilhinney]

Then something is really wrong. The Local Database option is for SQL Server CE while the Service-based Database option is for SQL Server Express. As I said, SQL Server CE uses SDF files and no server so the fact that the error message mentions an MDF file and attaching to a server means that you are not doing what you intended to. I think you need to start again.