Wednesday, March 21, 2012

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
Jason
What edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/d...displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:

> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>

No comments:

Post a Comment