Getting Error 1935 when trying to install SQLXML 3 SP3

I have a Windows 2003 Server SP1. I have SQL 2000 Server SP4 running on it. I am trying to instal SQL XML 3 SP3 on this server. But the installation aborts midway giving an error.I got the following in the event log.

Product: SQLXML 3.0 SP3 -- Error 1935. An error occured during the installation of assembly component {303994BA-6487-47AE-AF1D-7AF6088EEBDB}. HRESULT: 0x80070002. assembly interface: IAssemblyCacheItem, function: Commit, assembly name: Microsoft.MSXML2,publicKeyToken="6bd6b9abf345378f",version="4.20.9818.0",type="win32",processorArchitecture="x86"

Please help. Thanks in advance

Rupesh NairThis may be due to another process locking MSXML4.dll. You may need to shutdown any applications that may be using MSXML4.dll and then retry the install.

If you are unsure which of your processes may be using MSXML4.dll, you can use a tool like ListDlls from SysInternals to determine which process is holding onto it.

Give this a try, and see if it works out.

|||

Another issue that can cause this is if you are using Ad-Watch SE Professional and have it active. Simply turn it off and then the SQLXML will install completely.

I hope this helps.

Marcus.......

|||

SpySweeper Enterprise Edition also causes the same issue.

Kill SpySweeper.exe and SpySweeperTray.exe from Task Manager, and the install will be successful.

|||

Please read the posting more carefully. The problem is the inability to deploy the MSXML4 assembly files to the WinSXS folder.

I have encountered this problem frequently in just the past two weeks wherever I am installing a software package that includes the Microsoft MSXML4sxs32.msm Merge Module. The packages have been using this merge module for two years, but just began showing this problem within the last two weeks.

MSI (s) (F8:28) [17:35:39:702]: Executing op: SetTargetFolder(Folder=C:\WINDOWS\system32\SXS\)
MSI (s) (F8:28) [17:35:39:702]: Executing op: SetSourceFolder(Folder=1\System32\SXS\)
MSI (s) (F8:28) [17:35:39:702]: Executing op: AssemblyCopy(SourceName=msxml4.dll,SourceCabKey=msxml4.dll.sxs.2E8D8EBB_CC16_45E1_BBCA_CB1ED881EDB7,DestName=msxml4.dll,Attributes=16896,FileSize=1233920,PerTick=32768,,VerifyMedia=1,,,,,ComponentId={303994BA-6487-47AE-AF1D-7AF6088EEBDB},,,,AssemblyMode=0,)
MSI (s) (F8:28) [17:35:39:795]: Assembly Error:Access is denied.