SP4 update freezes during Install of MDAC

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SP4 update freezes during Install of MDAC

Author

Topic

jpaiva
Starting Member

3 Posts

Posted - 2007-12-19 : 11:44:12

I'm updateing SQL Server 2000 Developer Edition to SP4. It never gets past the point of "Installing MDAC".
I downloaded MDAC 2.8 and installed it with no errors, Ran the SP4 update again and it still gets stuck at the same spot. Any ideas?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-19 : 11:46:08

On what operation system are you running SQL Server 2000 Developer Edition?

E 12°55'05.25"
N 56°04'39.16"

jpaiva
Starting Member

3 Posts

Posted - 2007-12-19 : 14:47:56

i'm running Windows 2000.
when i run "@@version" this is what i get

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) ~ Dec 17 2002 14:22:05 ~ Copyright (c) 1988-2003 Microsoft Corporation~ Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-19 : 15:13:55

Any details in installation log file?

jpaiva
Starting Member

3 Posts

Posted - 2007-12-20 : 08:18:50

The end of the installation log is:

06:36:03 SQL program folder: C:\Program Files\Microsoft SQL Server\MSSQL
06:36:03 SQL data folder: C:\Program Files\Microsoft SQL Server\MSSQL
06:36:03 Windows system folder: C:\WINNT\system3206:36:03 Prog req: 62791, Data req: 3072, Sys req: 50645
06:36:03 Prog avail: 23973288, Data avail: 23973288, Sys avail: 23973288
06:36:03 Prog req vs. avail, 116508, 23973288
06:36:03 Data req vs. avail, 3072, 23973288
06:36:03 Sys req vs. avail, 53717, 23973288
06:36:03 SQLManagerApplicationClass found
06:38:03 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Timeout 5000 -Service SQLSERVERAGENT
06:38:03 Process Exit Code: (0)
06:38:03 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Timeout 5000 -Service MSSQLSERVER
06:38:03 Process Exit Code: (0)
06:38:03 Begin: InstallPkgs(ID_INSTALLMDAC)
06:38:03 Begin Action: Locked Connectivity Files Check
06:38:04 ConnectivityLocked returned: 3010
06:38:04 The requested operation is successful. Changes will not be effective until the system is rebooted.

06:38:04 End Action: Locked Connectivity Files Check
06:38:04 Setup is installing Microsoft Data Access Components (MDAC) ...
06:38:04 C:\SQL2KSP4\x86\Other\sqlredis.exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS"
06:38:04 Unloading library - sqlsut.dll (#U2)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-20 : 16:23:23

It didn't say installation filed. Tried reboot then apply sp4 again?

cscheuble
Starting Member

2 Posts

Posted - 2012-07-27 : 02:50:07

I'm getting the same thing. SQL Server 2000 on Windows 2003 SBS Server.

C:\WINDOWS\sqlsp.log log file ends with this:
...
23:12:04 Begin: InstallPkgs(ID_INSTALLMDAC)
23:12:04 Begin Action: Locked Connectivity Files Check
23:12:04 ConnectivityLocked returned: 0
23:12:04 The operation completed successfully.

23:12:04 End Action: Locked Connectivity Files Check
23:12:04 Setup is installing Microsoft Data Access Components (MDAC) ...
23:12:04 C:\Raw\MS\SQL2KSP4\x86\Other\sqlredis.exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS"
23:12:04 Unloading library - sqlsut.dll (#U2)

Then nothing. No error. No timeout. No CPU or I/O. The screen displays:
Setup is installing Microsoft Data Access Components (MDAC) ...

I wonder if jpaiva ever solved this.

I ran MDAC CompChecker and it shows I'm running the latest and greatest 2.8 MDAC.

Rebooted machine and tried again. No difference.

I was prompted to update SQL Server 2000 to SP4 when I saw the security update http://support.microsoft.com/kb/960082 for SP4 fail.

Chris

cscheuble
Starting Member

2 Posts

Posted - 2012-07-27 : 05:03:13

I got around this by killing the child process. Before I had killed the parent install process. Killing the child process allowed the parent install process to go to the next step.
The log file ended with this:

01:45:34 End: PostSetupRegistry()
01:54:00 You should now backup your master and msdb databases since this installation has updated their content.
01:54:00 Action CleanUpInstall:
01:54:00 Installation Completed with Errors (number of nonfatal errors: 1)

Chris

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-07-27 : 08:08:29

Thank you for the update.

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources