I am having all sorts of problems with SP1 for desktop engine.
With regards to the message 'This installation package could not be opened' it seems that the msi file that was used to install desktop engine needs to exist preferably in the same location that it was run from. The service pack setup.exe requires the parameter /p <Patch Path> INSTANCENAME=<Instance Name> where <Patch Path> is either the path to the msp file or SQLRUN and <Instance Name> is the name of the instance to apply the service pack to.
I also discovered that if using SQL authentication UPGRADEUSER=sa needs to be specified too otherwise the install will fail when it attempts to run some scripts by logging in with Windows authentication. Also, I can only get it to work when specifying the data path using DATADIR if the data path is not the default. This is proving to be a problem if the instance is an upgraded MSDE 1.0 as \MSSQL is appended to whatever path is specified for DATADIR and the original MSDE install is not likely to conform to the 2000 install path structure. Does anyone have any info on how to deal with this?
Andy (different one!).
Edited by - inforamtion on 07/19/2001 09:18:21 AM