/build/static/layout/Breadcrumb_cap_w.png

SQL Server 2000 Client install fail when deploy by using PSexec

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

Answers (3)

Posted by: anonymous_9363 13 years ago
Red Belt
0
Do you have MSXML6 installed as a pre-requisite?
Posted by: Savage455 13 years ago
Orange Belt
0
Thanks for your reply and yes, it is installed previously.
Posted by: anonymous_9363 13 years ago
Red Belt
0
Extract the MSI, transform it and use that combination.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ