What kind or error am I looking for?!

  • I am implementing SP2 and hotfix KB934459 on a SQL2005 instance in a cluster and receive the following error:

    "Update 'Hotfix 3159 for SQL Server Database Services 2005 (64-bit) ENU (KB934459)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934459_sqlrun_sql.msp.log."

    When I look into the mentioened log I see an enormous amount of text and have no idea what to look for. When I search for 'error' I find 100s maybe 1000s of hits, which do not indicate a real error but are descriptive of nature, some standard text. When I find some meaningfull text on error, it is basically the reference to this logfile, that is: itself!

    When opening SSMS I can see the correct version number. When calling SELECT @@Version I receive the correct version as well. Everything seems to be working fine. Before I go i9nto extensive testing I would like to know what this error message is telling me, and I would like some pointers how to search an errorlog like this for clues on what is actually wrong.

    Any hints?

    Greetz,
    Hans Brouwer

  • i've had this as well

    first check to make sure the default database path is the same as what it was when you first installed SQL. there is a bug with the installers where it has to update the resource databases and it won't find them because it looks in whatever the new default database path is.

    and rerun it again. i've had it where the default database path was OK. SP3 update failed but the build version was OK. i reran it and it ran OK. i think the error was it couldn't start the service due to a reboot requirement

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply