I've created a package to install Client tools of SQL Server 2000 on windows XP.

Command: x86\setup\setupsql.exe k=SMS -s -m -SMS -f1 "sqlcli.iss".

It was working fine when you do a normal double click installation. But when you using Psexec to install it remotely it fails.

Below is the error lines from sqlstp.log

10:23:23 Begin Action: Locked Connectivity Files Check
10:23:23 End Action: Locked Connectivity Files Check
10:23:23 Setup is installing Microsoft Data Access Components (MDAC) ...
10:23:23 C:\EDT\SQLSER~1\x86\Other\sqlredis.exe /q:a
10:23:53 ExitCode: -1
10:23:53 Installation of the Microsoft Data Access Components package failed. (-1)

10:23:53 Action CleanUpInstall:
10:23:53 StatsGenerate returned: 2
10:23:53 StatsGenerate (0x20004,0x1,0xf000000,0x300,1033,303,0x0,0x1,0,0,0
10:23:53 StatsGenerate -1,e501643)
10:23:53 Installation Failed.


Below is the error lines from setupapi.log

#-199 Executing "C:\TEMP\IXP000.TMP\dasetup.exe" with command line: /Q /N
#E359 An unsigned or incorrectly signed file "c:\temp\ixp000.tmp\rspfiles.inf" blocked (server install). Error 1168: Element not found.
#W187 Install failed, attempting to restore original files.
#E064 Parsing install section [DefaultInstall.NT] in "C:\TEMP\IXP000.TMP\rspfiles.inf" failed. Error 1168: Element not found.

Apparently it is the MDAC cause the problem, but I just couldn't find a solution(Already tried http://support.microsoft.com/default.aspx?scid=kb;en-us;286442 without luck) after I do tons of search on the Internet and in this forum. Does anybody here have met this issue before ? Any suggestions?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Do you have MSXML6 installed as a pre-requisite?
Answered 01/25/2011 by: VBScab
Red Belt

Please log in to comment
0
Thanks for your reply and yes, it is installed previously.
Answered 01/25/2011 by: Savage455
Orange Belt

Please log in to comment
0
Extract the MSI, transform it and use that combination.
Answered 01/26/2011 by: VBScab
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity