468,484 Members | 1,587 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,484 developers. It's quick & easy.

SQL Server 2005 + SQL Server Express

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
2 1484
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
Thank you..

Aug 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chris | last post: by
1 post views Thread by Darryl Kerkeslager | last post: by
10 posts views Thread by amjad | last post: by
14 posts views Thread by Developer | last post: by
2 posts views Thread by kress1963nov22 | last post: by
3 posts views Thread by leonaisse | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by gieforce | last post: by
reply views Thread by theflame83 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.