Running Sql Server Developer Edition with VS 2005 and ASP.NET

I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work.

It says SQl Server express must be installed.

I would like to use the full developer edition to link to my projects.

Can someone help?

Thanks,

Mike G

In your connection string in web.config in your ASP.Net projects, are you pointing to SQLExpress, or have you configured it to connect to your Dev Edition SQL Server? More details on your configuration and error message would help.|||

I am having the same problem. When I try to add a new sql database to an asp.net web application using the following steps:

1. Right-click the App_Data folder

2. Select "Add New Item"

3. Select Sql Database

4. Change SQL Database name to xxxxxx.mdf

5. Click "Add"

I then get the following message:

"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."

I am using VS 2005 Professional and SQL Server 2005 Standard Edition. I want to be able to do this with SSE. In VS2005 I have gone to Tools...Options...Database Tools...Data Connections and changed the SQL Server Instance Name from SQLEXPRESS to MSSQLSERVER. Should I make it the name of my server?

Any help would be greatly appreciated.

John

|||

By using App_Data it appears you're forced into using SQL Express, because you're defining a connection to a physical database file, rather than establishing a connection string to an existing server.

In my web.config file I configure an application variable called ConnectionString containing something like this:

Integrated Security=True;Data Source=MyServer;Initial Catalog=MyDatabase;Application Name=MyApp;

Then I configure a SQL Connection object and set the .ConnectionString property to the application connection string. After that all is well.

|||

So does that mean the App_Data folder is only used with SQL Server Express and not to be used with SQL Server 2005?

John