SQL Server Developer Center > SQL Server Forums > SQL Server Setup & Upgrade > SQL Server 2005 Express SP3 and Toolkit silent installation; work around troubling package: MSXML 6 Service Pack 2 (KB954459) version 6.20.1099.0
Ask a questionAsk a question
 

QuestionSQL Server 2005 Express SP3 and Toolkit silent installation; work around troubling package: MSXML 6 Service Pack 2 (KB954459) version 6.20.1099.0

  • Wednesday, November 04, 2009 12:24 AMAlex Seleznev Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Dear Colleagues,
    here is a question about subsequent silent Installation of SQL Server Express 2005 SP3 (version 9.00.4035.00, named instance) and SQL Express Toolkit (Microsoft SQL 2005 Server Express Edition)

    Operating System: Windows XP SP3

    Task: installation of AMO product with prerequisites, including SQL Express SP3 (named instance) and Toolkit for legacy data conversion
    (in our case - Access data)

    on clean machines all installations go through without a glitch

    BUT:

    1). if target machine already has MSXML 6 Service Pack 2 (KB954459) version 6.20.1099.0 installed - SQL Express SP3 installation errors out, it's 
         know problem:
         http://support.microsoft.com/default.aspx/kb/968749
        
         question: any possible suggestions on how to bypass the problem and not involve customers in manual removal of MSXML 6 Service Pack 2..?
                        [something like /qb ADDLOCAL=list_of_all_sql_components_with_no_SQLXML ?]
                        ~ currently I use /qb ADDLOCAL=SQL_Engine

    2). if target machine already has SQL Server Express 2005 Advanced Services installed (version 9.00.3042.00) then:
         installation of Toolkit errors out and fails to install several components including DTS client (and we need DTS..!) because this feature is already installed.

         question: would partial installation of Toolkit be possible answer..?
                        [something like /qb ADDLOCAL=DTS_component_only ?]
                        ~ currently I use /qb ADDLOCAL=All
         if partial installation of Toolkit is not the answer, would you suggest a good solution?

    Many thanks in advance,

    ~Alex S

All Replies

  • Wednesday, November 04, 2009 12:43 AMLekss Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Hi Alex,

    SQL_Engine is a bunch of components that needs all the components to function properly (even to be installed).
    And right now microsoft has just three options at the server level  - SQL_Engine , REPLICATION and FULLTEXT.There is no way to specify without MSSQLXML.

    The switch qb (for tools)takes only parameters like  - BOL , BC , BIDS , Conn , SSMS , ADV_SSMS and SDK.
    Again no separate options to specify only DTS.

    I would guess the answer is NO for both the questions.


    Thanks, Leks
  • Wednesday, November 04, 2009 6:24 PMAlex Seleznev Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi Leks,

    many thanks for your answer, eventhough it is "No" answer;

    God bless,

    ~Alex