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?
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)
Please log in to answer
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.