Re: Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end

Aaron,

Thanks for the advice.

I think the answer from Charles Wang is actually addressing the cause (see
below).
--
Thanks,

Bill T.


"Aaron Bertrand [SQL Server MVP]" wrote:

Did you try running the setup from a local drive instead of over the
network? I never, ever, EVER try to install anything from a file server.


On 3/23/09 8:08 PM, in article
CAD18E22-C63A-436C-99CC-2E26226CC70C@xxxxxxxxxxxxx, "BILL T." <BILL
T.@xxxxxxxxxxxxxxxx> wrote:

I have a Enterprise edition Server 2003 running the Enterprise Edition of SQL
2005.

I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express
edition loaded on the server to support a Tape Backup Program.

Part of the upgrades, patched the SQL Express edition to SP2. This caused a
known problem with the SQL 2005 Maintenance Wizard, and the fix was
documented to update SQL 2005 to SP2 to correct the .dll that the Express
Edtion SP2 had corrupted.

I had updated two other SQL 2005 servers to SP2 from the Windows Update site
successfully. For this server I downloaded the SP2 file to our network, onto
one of our file servers.

I ran the SQL 2005 SP2 x86 edition patch from the file server. I watched
the entire SP2 load and it seemed to be nearly complete, having updated the
registry, and removed backup files, it then came to the end and gave me a
message: A recent applied update KB921896 failed to install.

I searched the appropriate log and found this one reference to a failure:
MSP Error: 29537 SQL Server Setup has encountered the following problem:
[Microsoft][SQL Native Client][SQL Server]Directory lookup for the file
"D:\temp_MS_AgentSigningCertificate_database.mdf" failed with the operating
system error 21(The device is not ready.).. To continue, correct the problem,
and then run SQL Server Setup again.

I also searched the Application and System event logs and found this
reference to an error: Product: Microsoft SQL Server 2005 - Update 'Service
Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be
installed. Error code 1603. Additional information is available in the log
file C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

This log is really long and complex, no simple error to find there.

I have researched many forums but have only found references to having moved
the default location of one of the system databases as the culprit. I have
moved my TEMP DB to a new location, but have left my master, msdn, and model
databases in the default locations.

The error references our (D:) drive as the device that was not ready, but
that is our CD-ROM drive and there was nothing loaded.

I can not find anyway to correct the problem, and or run the update again,
because it thinks it is up-to-date at SP2.

All of my databases are working as expected, the Maintenacne Wizard allowed
me to create a new database maintenance and backup. I can not see any way
that the SQL 2005 server is mis-behaving, yet I am curious about this SP2
update error.

Can anyone help me determine if I have a problem that I need to correct?

Does updgrading to SQL 2005 SP3 solve this problem ( the one that I can not
determine I have ) ?

I can supply the registry keys, etc. that I have seen other forums ask for,
just let me know.


.

Relevant Pages

  • Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... I have a Enterprise edition Server 2003 running the Enterprise Edition of SQL ... I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot see SQL Jobs on remote server
    ... Now I installed SP2 for SQL Server and the problem ... Try applying SQL ... Server 2005 SP2 on your PC. ...
    (microsoft.public.sqlserver.connect)
  • Re: Public role not in server role
    ... SP2 look for 9.00.3042 or higher. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Any help here???
    ... SQL 200 Server is not local - it's on separate server all by itself. ... trust me - all that's been done here was to install SP2 or upgrade of XP from ... I've completed the install of Visual Studio.NET like I've ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... I never, ever, EVER try to install anything from a file server. ... I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express ...
    (microsoft.public.sqlserver.setup)
Loading