Hi

My server environment - Windows Server 2003 SP2 and SQL Server 2005
Standard Editon with SP2

while installing the SQL Server 2005 SP3 the setup fails and i am getting
the A recently applied update, KB955706, failed to install.

In Hotfix log i found the following the error message.

08/08/2009 11:45:19.136 Installing instance: QA
08/08/2009 11:45:19.167 Enumerating passive cluster nodes
08/08/2009 11:45:19.183 Patching available passive node: BLRFOCDB2
08/08/2009 11:45:19.199 Patching passive node: BLRFOCDB2
08/08/2009 11:45:19.214 Waiting for first completed passive node
08/08/2009 11:45:19.261 Task Scheduler: Created remote folder for product
instance target \\BLRFOCDB2
08/08/2009 11:45:19.386 Task Scheduler: Error, cannot copy file
\\BLRFOCDB2\C$\UpdateTemp_9\batchparser90.dll, error 5
08/08/2009 11:45:19.402 Task Scheduler: Error, cannot copy file
\\BLRFOCDB2\C$\UpdateTemp_9\batchparser90.dll
08/08/2009 11:45:19.417 Task Scheduler: Error, cannot transfer payload to
remote product instance target \\BLRFOCDB2
08/08/2009 11:45:19.433 Task Scheduler: Error, cannot transfer payload to
remote product instance target \\BLRFOCDB2
08/08/2009 11:45:19.464 Error, remote process failed for product instance
target
08/08/2009 11:45:19.480 Exit code for passive node: BLRFOCDB2 = 1603

Please help me on this issue, how to resolve this issue.

Thanks
Surendra

Hi Surendra,

I had the same issue by reinstalling the SP3.

Here below is what I found on the MSDN social.

CAUSE:
By default the setup creates the Temp_MS_AgentSigningCertificate_database
Database
on specified default database location,
If the location doesn't exist, it fails to create the database and the setup
fails.


RESOLUTION:

1. In SSMS, go to Server Properties > Database Settings > Database Default
Locations ,check default location for Data and Log .
2. Try to access locations specified at Data and Log, Make sure files are
available
there.
3. If any of the files missing from above location , we hit the above error.
4. In that case, change the path to point to reall location of mdf/ldf files .
5. Setup should now succeed.

Also, another nice blog explaining the same issue...
http://blogs.msdn.com/sqlserverfaq/a...-msp-file.aspx

Regards,

Pluto

"Surendra Kavali" wrote:

Hi Pluto,

Thanks for your reply..!!

My Server Default Database locations are correct.[S:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data]

The Mdf/Ldf files are located on the Default Database Locations.

Thanks
Surendra

"Pluto" wrote: