Is it possible to install SQL Express and SQL Server

[jtrembla]

Is it possible to install SQL Express and SQL Server on the same machine?

The problem is I need to create a distributable .net windows application and I was planning on using SQL Express as the backend database. If I recall it is not possible to package a SQL Server database with the app? Or am I incorrect?

Thanks,

 

[mrdenny]

Yes you can install SQL Express and SQL Server on the same machine. Each instance will need to have a seperate instance name.

You can package SQL Express or MSDE will an application, but you can not bundle full blown SQL Server. If you do you'll have to include a license for SQL Server and add that to the cost.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com