By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,296 Members | 1,428 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,296 IT Pros & Developers. It's quick & easy.

SQL Server 2005 + SQL Server Express

P: n/a
Hi,
I have SQL Server 2005 installed on my dev system. I am working on an
app that i would like to distribute SQL Server with. SQL Server
EXpress edition seem to be ideal for this. My questions are:

-If i installed Express Edition, Can both SQL Server 2005 and Express
Edition coincide peacefully on the same PC?

-Which one will Visual Studio see? (currently i created by database
using VS, which i assumed created a SQL Server 2005 database, since
that is the sql server i have installed).

-When VS2005 is installed, which SQL Server is installed and how can i
tell which one VS2005 is using if i have both SQL servers (2005 and
Express) installed?

thanks much

Aug 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
farseer (fa*****@optonline.net) writes:
-If i installed Express Edition, Can both SQL Server 2005 and Express
Edition coincide peacefully on the same PC?
Yes. SQL Server permits multiple instances being installed on the same
server, and this can be multiple instance of Express Edition, multiple
instance of, say, Enterprise Edition, or any mix thereof.

Furthermore, to prevent collisions, SQL Express installs by default as
a named instance, \SQLEXPRESS whereas other editions of SQL Server by
default installs as default instances, which do not have any extra
name,
-Which one will Visual Studio see?
The one you point it to. I assume here that you mean the database that
you connect to for development purposes.

Some parts of VS like the compoent in Team System for Database
development uses the Express instance for its own storage.
-When VS2005 is installed, which SQL Server is installed and how can i
tell which one VS2005 is using if i have both SQL servers (2005 and
Express) installed?
That is in the, eh, is it called Server Explorer? And you can work with
muiltiple servers.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 8 '06 #2

P: n/a
Thank you..

Aug 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.