Patching SqlRun_Sql.msi not successful

Hi all,

when I tried to integrate SP1 into my install media (32bit Developer Edition) by using

msiexec /i sqlrun_sql.msi shortfilename=true /p sqlrun_sql.msp

using the msp from an extracted SP1 full web download I ended up with a modified msi file. But installing from this one I received an error:

"sysdbupg.sql.<some_guid> was not found in Sql.CAB"

Any ideas how to fix that?

With best regards,

Artus

Hey Artus, what is it specifically that you're trying to integrate? Are you able to change your install cmd to call the SP1 exe instead? Are you confined to call the msp's directly? This gets a bit sticky and we'd prefer to stay with the exe if possible.

Thanks,
Sam Lester (MSFT)

|||

Hi Sam,

for the university I am at we are looking for a solution to deploy SQL Server 2005 to several dozens of computers. It is though not feasible for us to get someone manually installing SQL Server to each computer that is why we are

(1) looking for a program to write an appropriate MST file [any hints appreciated] to deploy custom installation for our AD forest

(2) integrating SP1 and the hotfix rollup for SP1 into the install media *

And for (2) I extracted the SP1 web download, searched for the MSPs and now try to integrate them into the corresponding MSIs.

With kind regards,

Artus

*.) We don't get any of the two updates delivered by Microsoft Update opposite to what we expected when we migrated to Microsoft Update. If WSUS will deliver both the SP1 and the rollup we were fine with that, too

|||Still any help appreciated :-)|||

Running the MSP directly to upgrade to SP1 is not supported. You should look at launching the hotfix.exe using the unattended command-line flags, such as /quiet and /allinstances.

SQL Server SP1 has just been published to Microsoft Update so you can also obatin the update from there.

Peter