Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express

Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express

Post by Paol » Wed, 21 Dec 2005 10:51:41


I have just installed (hopefully) SQL 2005 Professional, as part of the
Visual Studio Professional setup. I already had SQL Server 2000, and SQL
Server espress, installed as part of Visual Web Developer. I chose a full
installation ( so that I would get the sample databases, etc...).
I chose the Default instance. (it was the default choice-(but was it trying
to upgrade SQL Express?))

Everything completed without any errors.

However, I can not find the 2005 equivalent of EnterpriseManager. In
startup, when I go to the list of programs, in the Microsoft Server 2005
folder tree, all I have is Configuration Tools.

I must have messed up somewhere. If I click SQL Server Configuration
Manager, I see the SQL Server 2005 Services (on the left) and then on the
right hand pannel, SQL Server is listed as (SQLExpress Running
Automatic...)

I looked at SQL Express, and the new databases that supposedly were to be
installed as examples are not there.

How do I get the full version 2005 to show up, with whatever Enterprise
Manager is called in 2005, and the rest of the services(which I believe I do
have installed, and sample databases to show up, please?

TIA,

Paolo
 
 
 

Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express

Post by Paol » Wed, 21 Dec 2005 11:01:09

Sorry, I mis-posted this, I will try it on the Setup forum. (Unless some
guru here can help?).

Paolo

 
 
 

Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express

Post by VW11dCBOYX » Wed, 21 Dec 2005 23:23:02

You should install SQL 2005 Client Tools.

EM, QA replaced with Management Studio..