SQL Server Q&A

As a software engineer, I focus on .NET, especially asp.net, C#, WCF and so on, and I am also very interested in Search Engine Optimization.

Entries Tagged ‘MSXML’

FIX: AV When You Call MSXML 2.6 Parser from a Stored Procedure

Symptoms
When you use the MSXML 2.6 parser from a stored procedure, you may encounter an access violation in the parser (Msxml2.dll). This particular exception is characterized by the call stack shown in the “More Information” section of this article.
Resolution
This is an issue with the garbage collection subsystem of MSXML2.

FIX: SQL Server 2008 Setup fails if you installed the security update package 954459 for MSXML Core Services 6.0

Symptoms
Consider the following scenario:On a computer that is running Windows Server 2003 or Windows XP, you apply the update for Microsoft XML Core Services (MSXML) 6.0 that is described in the following Microsoft Knowledge Base article:

954459?(http://support.microsoft.com/kb/954459/) MS08-069: Description of the security update for XML Core Services 6.0: November 11, 2008After you apply this MSXML update, you try to install Microsoft SQL Server 2008 with a language different from the operating system’s language.For example, you try to install the English version of SQL Server 2008 in the Chinese version of Windows Server 2003.In this scenario, SQL Server 2008 Setup fails. If you examine the SQL Server setup log file, you find that the following error has been logged:

Slp: Running Action: Install_Msxml6_Cpu64_Action
Slp: Target package: <drive>:\x86\setup\x86\msxml6.msi
Slp: InstallPackage: MsiInstallProduct returned the result code 1603.
If you examine the MSXML setup log file, you may find that the following error has been logged:

Action start Time: SkipInstallCA.
This package is not supported on this operating system.
Action ended Time: SkipInstallCA. Return value 3.
Action ended Time: INSTALL. Return value 3
MSI (s) (9C:00) [Time]: Note: 1: 1729
MSI (s) (9C:00) [Time]: Product: MSXML 6 Service Pack 2 (KB954459) — Configuration failed. ……
MSI (s) (A0:D0) [Time]: Note: 1: 1708
MSI (s) (A0:D0) [Time]: Product: MSXML 6 Service Pack 2 (KB954459) — Installation failed. Note You can find the setup log files in the following folder:
%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LogNote This problem affects all the editions and releases of SQL Server 2008 that are earlier than SQL Server 2008 Service Pack 1.
Resolution
The SQL Server 2008 Setup package contains an MSXML 6.0 version that is earlierthan the version that is described in Knowledge Base article 954459.Because the operating system language is different, SQL Server 2008does not detect that a higher version already exists. Therefore, SQL Server 2008 Setup tries to install the MSXML 6.0 version in the package and fails.