| Author |
 Topic  |
|
|
jpaiva
Starting Member
3 Posts |
 Posted - 12/19/2007 : 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
Sweden
29138 Posts |
Posted - 12/19/2007 : 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 - 12/19/2007 : 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
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 12/19/2007 : 15:13:55
|
| Any details in installation log file? |
|
|
|
jpaiva
Starting Member
3 Posts |
Posted - 12/20/2007 : 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
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 12/20/2007 : 16:23:23
|
| It didn't say installation filed. Tried reboot then apply sp4 again? |
|
|
|
cscheuble
Starting Member
2 Posts |
Posted - 07/27/2012 : 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 - 07/27/2012 : 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
Sweden
29138 Posts |
Posted - 07/27/2012 : 08:08:29
|
Thank you for the update.
N 56°04'39.26"
E 12°55'05.63" |
|
|
| |
Topic |
|
SP4 update freezes during Install of MDAC
