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

Question

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

Answer 1

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

Answer 2

Hi Leks,

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

God bless,

~Alex