SQL Server 2005 + SQL Server Express

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • farseer
    #1

    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

    Tags: None
    • Erland Sommarskog
      #2
      Re: SQL Server 2005 + SQL Server Express

      farseer (farseer@optonl ine.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, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • farseer
          #3
          Re: SQL Server 2005 + SQL Server Express

          Thank you..

            Comment

            Previous template Next
            Working...