SP1 installation problem

Hot Topic

SQL2005 Management Studio malfunction altering user after (SQL2000) db attachment
Cant find SQL Profiler
ArgumentNullException thrown after second connection
Simple Todays date query question
INNER JOIN between a CLR-TVF and a table returns no rows
Error when installing
Newbie to optimization
Calculated Measu Wierd scaling issue when subtracting two decimal numbers
New Oracle Data Provider for .NET (ODP .NET) 10.2.0.2.20 failure.
dml without generating log transactions ?

SQL Server

Reporting Service
Table visibility
Installation on Vista
How to find a record
MDF and NDF question
sql server on xp??
Can I install to C and put data on E?
Problem with two consecutive calls to CallableStatement (jdbc driver 1.1, SQLServer 2005)
SSIS Classes -- Recommendations (Brian Knight's classes are full)
Login failed for user '(null)'

SP1 installation problem

I recently tried to install SP1 on an instance of SQL Server 2005 standard edition, running on Win2003 Small Business Server. The installation ran with no error, except that it took a very long time, almost an hour, much more than the same installation on another similar server. After the SP1 installation, the instance of SQL Server 2005 is still in RTM version (9.00.1399.06) instead of being in SP1 version. We ran the installation again with the same result. Does someone have any suggestion about the cause and the solution

Thanks

Answer this question

SP1 installation problem

  • sally_de

    Did you check the sp1 log file for any errors See if any component update failed under %windir%\hotfix\hotfix.log, it has something like following:

    07/14/2006 17:46:01.614 Product Status Summary:
    07/14/2006 17:46:01.614 Product: SQL Server Native Client
    07/14/2006 17:46:01.614 SQL Server Native Client (RTM ) - Success
    07/14/2006 17:46:01.614
    07/14/2006 17:46:01.614 Product: Setup Support Files
    07/14/2006 17:46:01.614 Setup Support Files (RTM ) - Success
    07/14/2006 17:46:01.614
    07/14/2006 17:46:01.614 Product: Database Services
    07/14/2006 17:46:01.614 Database Services (RTM 1399 ENU) - Success
    07/14/2006 17:46:01.614
    07/14/2006 17:46:01.614 Product: Integration Services
    07/14/2006 17:46:01.614 Integration Services (RTM 1399 ENU) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Product: Client Components
    07/14/2006 17:46:01.629 Client Components (RTM 1399 ENU) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Product: MSXML 6.0 Parser
    07/14/2006 17:46:01.629 MSXML 6.0 Parser (RTM ) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Product: SQLXML4
    07/14/2006 17:46:01.629 SQLXML4 (RTM ) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Product: Backward Compatibility
    07/14/2006 17:46:01.629 Backward Compatibility (RTM ) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Product: Microsoft SQL Server VSS Writer
    07/14/2006 17:46:01.629 Microsoft SQL Server VSS Writer (RTM ) - Success
    07/14/2006 17:46:01.629
    07/14/2006 17:46:01.629 Hotfix package completed
    07/14/2006 17:46:01.770 Hotfix package closed

    For example, if Database Services component failed to upgrade, you can then check log files under %windir%\hotfix\SQL9\ to see why it failed.

    Thanks,

    Zhiqiang Feng



  • SP1 installation problem
Answer this question