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

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



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 express, 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 panel, 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




.



Relevant Pages

  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • RE: Error installing (KB 921896)
    ... Package Language: 1033 ... Package Platform: x86 ... Product Installation Status ... to SQL Server. ...
    (microsoft.public.windowsupdate)
  • RE: Upgrading to SQL 2005 ENT
    ... It gives a good step by step how to on upgrading to SQL Server 2005. ... I might not have IIS installed which might have ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • RE: Getting to the bottom of MSDE network connection problems ...
    ... the way using the same installation scenario on Win2K works with no problem. ... > various versions of MSDE and Windows XP ... > and it seems the problems are due to Windows XP and not MSDE. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ...
    (microsoft.public.sqlserver.msde)