However, I could not manage to install properly SQLServer2005 ExpressEdition,
while SQLServer2000 already locally installed (OS: Windows XP Pro / all
french editions).
SQLExpress service seems to run ok, but no access available to SQLExpress
Management Console (the equivalent of the former Enterprise Manager of
SQL2000).

Could you ? Thanks in advance.


"Geoff N. Hiten" wrote:

> You can choose to upgrade your existing installation or install a new copy
> of SQL 2005. If you install 2005 "side-by-side" with SQL 2000, at least one
> will have to be a named instance. Microsoft spent a lot of development time
> and money making sure the two systems didn't clobber each other. Not only
> do the database services work OK, the client tools even co-exist cleanly.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
>
> "DonW" <DonW@discussions.microsoft.com> wrote in message
> news:1C4D0699-3102-45FC-AF98-AD80A9771C68@microsoft.com...
> >I have SQL Server 2000 installed on my development computer. Can I install
> > SQL Server 2005 on the same machine so they will run side by side. I got
> > half
> > way through and it looked like it was going to upgrade 2000 so I stopped.
>
>
>

Hi,
My understanding of your issue is:
You thought you couldn't manage to install SQL Server 2005 Express Edition
because the SQLExpress Management Console was out of vision. You found that
the SQLExpress service worked fine.
If I have misunderstood, please let me know.

I'm glad to tell you that you have managed to install the SQL Server 2005
Express Edition. Unfortunately, SQL Server 2005 Express Edition doesn't
include management tools like SQL Server Enterprise Manager. It includes a
command line utility (sqlcmd) for management.
To use this function, click Start, click Run, and type sqlcmd.exe.
For its usage, you can refer to:
Using the sqlcmd Utility (SQL Server Express)
http://msdn2.microsoft.com/en-us/library/ms165702.aspx

If you want to use the management tool like SQL Server 2000 Enterprise
Manager, you need to install the client tool "SQL Server Management Studio
Express" which can be downloaded from:
http://msdn.microsoft.com/vstudio/express/sql/download/

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

OK. Actually, I just realise that SQL Server Management Studio Express is to
be installed separately.
Many thanks.

"Charles Wang[MSFT]" wrote:

> Hi,
> My understanding of your issue is:
> You thought you couldn't manage to install SQL Server 2005 Express Edition
> because the SQLExpress Management Console was out of vision. You found that
> the SQLExpress service worked fine.
> If I have misunderstood, please let me know.
>
> I'm glad to tell you that you have managed to install the SQL Server 2005
> Express Edition. Unfortunately, SQL Server 2005 Express Edition doesn't
> include management tools like SQL Server Enterprise Manager. It includes a
> command line utility (sqlcmd) for management.
> To use this function, click Start, click Run, and type sqlcmd.exe.
> For its usage, you can refer to:
> Using the sqlcmd Utility (SQL Server Express)
> http://msdn2.microsoft.com/en-us/library/ms165702.aspx
>
> If you want to use the management tool like SQL Server 2000 Enterprise
> Manager, you need to install the client tool "SQL Server Management Studio
> Express" which can be downloaded from:
> http://msdn.microsoft.com/vstudio/express/sql/download/
>
> If you have any other questions or concerns, please feel free to let me
> know. It's my pleasure to be of assistance.
>
> Charles Wang
> Microsoft Online Community Support
>
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>

Congratulations! You are welcome! :-)

Sincerely,
Charles Wang
Microsoft Online Community Support