SSEnterprise looking like Express

Tech-Archive recommends: Speed Up your PC by fixing your registry

Well, I got SQL Server 2005 Enterprise installed and my server didn't
explode, so I guess that's something to be thankful for.

SS2005Express was already on that server and installed Enterprise to a new
(or differently named) instance.

Now, when I view the server instances in SSMSE and ask for the properties
that belong to the Enterprise instance, it comes back and says it is
Express.

What do I need to do now?

By the way, it seems the two instances are sharing the databases. I didn't
realize that would happen - I kinda thought I would have no databases for
the newly installed Enterprise and would have to migrate (or at least given
a choice in the matter) the databases over from Express to Enterprise.



--
Remove INVALID from e-mail address.

Brian Smither
Smither Consulting
.

Relevant Pages

  • Re: SQLConnect
    ... the Enterprise Edition and the Standard Edition. ... each of these - as in the same path to each server through ... I have configured the test server to process the same data as the ... The only different here is SQL Server, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Standard vs. Enterprise edition
    ... I use Enterprise and Standard together in several situations, ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: SSEnterprise looking like Express
    ... I mean a new instance of SQL Server does not take over an existed instance's databases automatically. ... why do you still use SSMSE instead of SSMS if you have Enterprise Edition? ...
    (microsoft.public.sqlserver.setup)
  • Re: Open default DB in Enterprise Manager upon connecting to server (SQL2000)
    ... My hosting provider hosts ~500 databases on the server where my DB ... To open my database I use SQL Server 2000 Enterprise Manager. ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrading SBS 2000 to Enterprise versions
    ... Also once we shift from the standards to the enterprise version, do we still use the transition cals, or do we need to buy different ones? ... Once you remove the SBS server and move the FSMO roles to the Enterprise server...this is no longer an SBS domain..there are "contraints" remaining ... Windows Server and Exchange on new hardware, one machine for Server one for ...
    (microsoft.public.windows.server.sbs)