Can't create SQL 2005 database in VS 2005 1

[TonyScarpelli]

I'm using the developer version of Visual Studio 2005 and SQL Server 2005.

I've had SQL 2005 Express installed last year, and since moving up have been regretting putting anything Express on my system. I've never had so much agony trying to get rid of this junk.

I'm going through some video lessons and am creating a Web site. I then right click on the project, Add New Item, and add a SQL Database. I get the message to put it in the App_Data folder and say Yes.

At work I then get an error that the SQL Server 2005 Express is required. At home I get an error that I can't connect to the SQL Server.

I've uninstalled, and re-installed SQL Server 2005, and tried all the suggestions about getting rid of the Express version.

In tools, options I've set the database connection to my local SQL Server 2005 and that didn't work.

Yet, I can create a 2005 database outside the environment, and I can put a grid view on the page, and _can_ create a connection to that same database.

What am I missing inside the development environment?

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[TonyScarpelli]

I've come to find that just installing SQL Server 2005 Express solved this problem.

Also, in Tools, Options..., Database Tools, Data Connections, you have to have SQLEXPRESS.

For some reason Visual Studio 2005 or 2008 only like the Express version if you've previously installed it. Just can't get rid of all traces of the thing.

If I want to use SQL Server 2005 Developer version, it's just a matter of creating a connection to the table and using it that way.

Hope this helps someone.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102