Add New Database to solution

I'm running VS 2005 Enterprise, and SQL Server 2005 Developer / workgroup edition.

I'm trying to follow a few online examples to play around, and some of these examples require that you add a SQL DB to your solution by going:
-right click on website
-Add new Item
-Add SQL DataBase.

WHen I do that, I get the error that SQL Express isn't installed. Now the question is, why would I want SQL Express installed when I have SQL server 2005 already installed? My Machine can support it, but it's sort of a waste when I need to run SQL Server 2000, SQL Server 2005 and then SQL Server express all at the same time.

Any advice?

You are getting the error because you are using SQL Server as Access database when you have the developer edition which is the enterprise edition with deployment restrictions installed.

Now go to programs SQL Server, then management studio and then go to databases right click and go to new and then create a new database to create the blank database. To connect go to VS and click to datalink property and you should be able to connect. Hope this helps.

|||Caddre, thank you for the quick response! That solved it.|||I am glad I could help.