0

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?

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Ramesh S
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.