ASP.NET

ASP.NET RSS

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2007

Posts: 596

Reputation: buddylee17 has a spectacular aura about

Solved Threads: 125

buddylee17 buddylee17 is offline

Offline

Posting Pro

**Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function**

26 Days Ago

Windows Server 2003 Standard Edition Service Pack 2
SQL Server 2005 Standard
VS 2008

Hi everyone. I'm currently working on the following tutorial: http://www.asp.net/Learn/Security/tutorial-04-cs.aspx, but I get an error adding a SQL Server DB to the App_Data folder.
I right click App_Data, click Add New Item, SQL Server Database I get the following error:
---------------------------
Microsoft Visual Studio
---------------------------
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
---------------------------
OK Help
---------------------------
I purposely didn't install SQL Server Express because I already had the standard edition installed.
Does anyone know how to configure VS to use SQL Server 2005 instead of SSE?

Lost time is never found again.
- Benjamin Franklin

•

Join Date: Jun 2009

Posts: 432

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

24 Days Ago

Can you please post your connection string?

SQL Server standard edition does not support 'User Instance' clause in the connection string which is only supported in SQL Server Express Edition.

Also do not attach *.mdffile to SQL Server database each time when your code is to connected.

Refer this link.