I am trying to add a new database via the App_Data Folder and I receive an error described below.
I had attached an mdf file to try to use it in SQL Server 2008 Developer and Visual Studio 2010, which was is included in a book's lesson. Whenever I try to add a database within the App_Data Folder I get an error.
I can create a db by attaching an mdf via SQL Server Mgmt Studio, it connects fine, and I can see tables.
Mgmt Studio- Right Click Databases, Attach, Add, then once mdf is located:
The mdf file location, Database Name, Attach As, -- are all the same:
Do I need to change the Database Name?
Visual Studio- Server Explorer connects fine to mdf OR regular Database, I can see the tables.
However when I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly. Please verify the installation of the
component or download from the URl."
I tested this for both a normal dbo (non mdf) and the mdf.dbo I attached before, with the same error!
Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer. I had previously removed SQL Server Express.
View Complete Post