Home All Groups Group Topic Archive Search About

SQL Management Tools not installing

Author
19 Sep 2007 6:50 PM
Good2go
Hi all!
I'm getting an error trying to install the Management Tools either on the
server hosting SQL or on my workstation. Not sure of the reason, but whenever
I try it goes through the installation fine until it gets to actually
installing the components, then it errors out with a not very helpful error.
"Unexpected error occurred" is the gist of it.

Anyone have nay ideas how I can get the tools to install?

Author
19 Sep 2007 9:26 PM
Erland Sommarskog
Good2go (Good***@discussions.microsoft.com) writes:
> I'm getting an error trying to install the Management Tools either on
> the server hosting SQL or on my workstation. Not sure of the reason, but
> whenever I try it goes through the installation fine until it gets to
> actually installing the components, then it errors out with a not very
> helpful error. "Unexpected error occurred" is the gist of it.
>
> Anyone have nay ideas how I can get the tools to install?

Didn't you post about the same problem the other day? (I'm just asking
so that I am not suggesting the same thing all over again.)

From what media are you installing? Do you install the tools only? Have
you already installed the server part? (Not that I really have a clue
what is going on, but more information could always help.)


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
19 Sep 2007 9:50 PM
Good2go
Hi Erland!
Yes I did post the other day, but that was based on faulty log entries, so I
thought I was getting error X when in reality it's error Y.

SQL is 2005 Sp 2 installed on the server. Trying to install just the tools
with no sample DBs, no books on line, etc. Installing from a copy of the
CD/DVD on a local hard disk. This installed the SQL egine just fine, but when
I use it to install the tools, it's erroring out just when you get to the
actual component installation progress window. This happens on my workstation
(laptop) as well. I tried the actual media as well, but still had this same
issue on the server.

Show quote
"Erland Sommarskog" wrote:

> Good2go (Good***@discussions.microsoft.com) writes:
> > I'm getting an error trying to install the Management Tools either on
> > the server hosting SQL or on my workstation. Not sure of the reason, but
> > whenever I try it goes through the installation fine until it gets to
> > actually installing the components, then it errors out with a not very
> > helpful error. "Unexpected error occurred" is the gist of it.
> >
> > Anyone have nay ideas how I can get the tools to install?

> Didn't you post about the same problem the other day? (I'm just asking
> so that I am not suggesting the same thing all over again.)
>
> From what media are you installing? Do you install the tools only? Have
> you already installed the server part? (Not that I really have a clue
> what is going on, but more information could always help.)
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
Author
19 Sep 2007 10:18 PM
Erland Sommarskog
Good2go (Good***@discussions.microsoft.com) writes:
> SQL is 2005 Sp 2 installed on the server. Trying to install just the
> tools with no sample DBs, no books on line, etc. Installing from a copy
> of the CD/DVD on a local hard disk. This installed the SQL egine just
> fine, but when I use it to install the tools, it's erroring out just
> when you get to the actual component installation progress window. This
> happens on my workstation (laptop) as well. I tried the actual media as
> well, but still had this same issue on the server.

Could it be a case of bad media?

When you start the install, do you double-click on splash.hta, or do
you try something else?



--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
20 Sep 2007 4:58 PM
Good2go
I've done a variety of things. However, I was able to actually install the
database engine from the local drive (hard drive not CD/DVD) and I've tried
to install the tools from the same location and it's a no-go. It goes through
the installation fine (either double-clicking on setup.exe or splash.hta)
until it gets to the actual install of the files and then it errors out. And
it's one of those oh-so-informative error messages such as "setup couldn't
continue. For more information, click on help or review the logs."
Unfortunately I can't find the logs and the help is useless.

Show quote
"Erland Sommarskog" wrote:

> Good2go (Good***@discussions.microsoft.com) writes:
> > SQL is 2005 Sp 2 installed on the server. Trying to install just the
> > tools with no sample DBs, no books on line, etc. Installing from a copy
> > of the CD/DVD on a local hard disk. This installed the SQL egine just
> > fine, but when I use it to install the tools, it's erroring out just
> > when you get to the actual component installation progress window. This
> > happens on my workstation (laptop) as well. I tried the actual media as
> > well, but still had this same issue on the server.
>
> Could it be a case of bad media?
>
> When you start the install, do you double-click on splash.hta, or do
> you try something else?
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
Author
20 Sep 2007 9:53 PM
Erland Sommarskog
Good2go (Good***@discussions.microsoft.com) writes:
> I've done a variety of things. However, I was able to actually install
> the database engine from the local drive (hard drive not CD/DVD) and
> I've tried to install the tools from the same location and it's a no-go.
> It goes through the installation fine (either double-clicking on
> setup.exe or splash.hta) until it gets to the actual install of the
> files and then it errors out. And it's one of those oh-so-informative
> error messages such as "setup couldn't continue. For more information,
> click on help or review the logs."
> Unfortunately I can't find the logs and the help is useless.

On my machine, logs are under
"C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG" as well
as "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG". If you
have 32-bit SQL Server, all logs should be in the latter location. On a
64-bit, tool logs should be under x86, as tools 32-bit.

The problem is that the logs are very many and verbose. There is also
summary.txt in the LOG directory, and then in Files you find the logs
themselves.

You said that you install from the local drive. From where did you get
the files? Did you copy a CD, download or what? What I'm getting at is
that if you originally got the files from a CD, you need two CDs, the
tools are on a seprate CD. In the directory where you have a splash.hta
you should one folder Servers and one Tools. At least that's the way it
looks with a DVD; I haven't done a CD install as I can recall.

Yet a possibility is simply bad media. Either the disk you loaded from.
Or your hard drive.

There could also be conflict with some existing installation, whatever
that will be. You don't have Mgmt Studio Express installed, have you?

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
20 Sep 2007 10:32 PM
Good2go
I thought that second CD had a use. :)

Show quote
"Erland Sommarskog" wrote:

> Good2go (Good***@discussions.microsoft.com) writes:
> > I've done a variety of things. However, I was able to actually install
> > the database engine from the local drive (hard drive not CD/DVD) and
> > I've tried to install the tools from the same location and it's a no-go.
> > It goes through the installation fine (either double-clicking on
> > setup.exe or splash.hta) until it gets to the actual install of the
> > files and then it errors out. And it's one of those oh-so-informative
> > error messages such as "setup couldn't continue. For more information,
> > click on help or review the logs."
> > Unfortunately I can't find the logs and the help is useless.
>
> On my machine, logs are under
> "C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG" as well
> as "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG". If you
> have 32-bit SQL Server, all logs should be in the latter location. On a
> 64-bit, tool logs should be under x86, as tools 32-bit.
>
> The problem is that the logs are very many and verbose. There is also
> summary.txt in the LOG directory, and then in Files you find the logs
> themselves.
>
> You said that you install from the local drive. From where did you get
> the files? Did you copy a CD, download or what? What I'm getting at is
> that if you originally got the files from a CD, you need two CDs, the
> tools are on a seprate CD. In the directory where you have a splash.hta
> you should one folder Servers and one Tools. At least that's the way it
> looks with a DVD; I haven't done a CD install as I can recall.
>
> Yet a possibility is simply bad media. Either the disk you loaded from.
> Or your hard drive.
>
> There could also be conflict with some existing installation, whatever
> that will be. You don't have Mgmt Studio Express installed, have you?
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
Author
21 Sep 2007 10:17 PM
Erland Sommarskog
Good2go (Good***@discussions.microsoft.com) writes:
> I thought that second CD had a use. :)

So that was the problem?

Well, in such case, you are not the first one.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button