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.

This isn't supposed to happen. I mean a new instance of SQL Server does not
take over an existed instance's databases automatically. Also, a database
can not be shared among SQL Server instances. A database is owned\attached
only by one SQL Server instance.

Also, why do you still use SSMSE instead of SSMS if you have Enterprise
Edition? SSMSE is a limited version of SSMS.

Ensure the SQL Server instance you work on is Express or Enterprise Edition
by using the following command line:

SELECT serverproperty('edition')

--
Ekrem Önsoy

"Brian Smither" INVALIDcitlink.net> wrote in message
news:Xns9A7AB5658CEE8SmithCon@216.151.153.21...

Ekrem

I logged on to the Instance Name I gave to the SS2K5 Enterprise X64 that
I just finished installing (alongside SSE).

With @@SERVER, I get:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007
22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition
with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2)

With serverproperty('edition'), I get:
Express Edition with Advanced Services

The setup was quite extensive and I truly believe I got Enterprise X64
installed. But where is it?

Ekrem

SSMSE and SSMS can not be installed side by side. You should uninstall SSMSE
before trying to install SSMS.

Ensure that you click the Advanced button in the Components to Install
window in SQL Server Setup to install SSMS (it's in the Client Tools node)

--
Ekrem Önsoy

Go to Microsoft SQL Server 2005 menu from Start\Programs and open up SQL
Server Configuration Manager. Search for your instances of SQL Server from
the "SQL Server 2005 Services" node in the left pane. You'll see your
installed SQL Server instances there.

--
Ekrem Önsoy

"Brian Smither" INVALIDcitlink.net> wrote in message
news:Xns9A7B538CA275Faaom@207.46.248.16...

Also, in Management Studio, on the View menu, click Registered Servers.
In Registered Servers, right-click Database Engine, and then click Update
Local Server Registration.
Now you should see the Enterprise instance.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ekrem Önsoy" compecta.com> wrote in message
news:47EF9F34-99D6-426F-A714-15A2FC0CECE5@microsoft.com...

Yup, I have several names:

SQL Server Full Text Search (SqlExpress)(Previously installed)
SQL Server (SqlExpress)(Previously installed)
SQL Server Browser(Previously installed)(stopped)
SQL Server Agent (SQL2005ENT)(stopped)
SQL Server (SQL2005ENT)
SQL Server Full Text Search (SQL2005ENT)(stopped)
SQL Server Analysis Services (SQL2005ENT)(stopped)

The services that are stopped do not have a problem. I just have not
started them yet.

Now, SQL Server Express with Advanced Services supposedly gave me
Reporting Services via VS2005, but I don't see that listed.

Ekrem

Well, that's going to be a small problem. While my apps aren't mission
critical, somebody is going to notice if they don't work while I have one
DBMS system being uninstalled and another getting installed.

And, to my dismay, of all the research I made on installing SS2K5Ent, not
one article said "Don't do that."

Ekrem

No, sorry, only the SqlExpress shows up - nothing additional got added to
the list.

"Rick Byham, \(MSFT\)" REDMOND.CORP.MICROSOFT.COM> wrote in
news:D40B48C7-73BE-4C7E-B786-6C7159E95BA3@microsoft.com: