CODEWITHSUNDEEP
sql-servervisual-studio-2008solutionmdfsolution-explorer
Josh
Josh

Reputation: 13818

Cannot add database to an Asp.Net application

I'm unable to add an mdf database file by right clicking on the project name and clicking on "Add->New Item->SQL Server Database".

It gives me the following error...

**

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

**

Any ideas why and what I should do to correct this? Thanks

Upvotes: 0

Views: 566

Answers (1)

David
David

Reputation: 73564

Just specifying the instance name as SQLEXPRESS in the Instance name won't trick the system into thinking that you actually have the express version installed, so our first bullet point would not help.

Your second point says you uninstalled SQL Server 2005 Express, which is the opposite of what you need to do.

Did you ever have the true Express edition? (Not the Developer edition that installs with Visual Studio, but the actual SQL Server 2005 Express edition downloaded from the link you posted)?

Edit - Added

I see that the link takes you to the 2008 Express edition, not 2005. I would try going and getting the 2005 install from here instead: http://www.microsoft.com/express/sql/previous/register.aspx

Upvotes: 1

Related Questions