Solved

MS SQL 2000

Posted on 2009-04-08
10
442 Views
Last Modified: 2013-12-26
i was installing SP 4 on our production SQL server 2000 SP3, i am getting error message
A Service control operation failed for the MS SQLSERVER service 1460
This operation returned because the timeout period expired

This is production server please help me to get start or go back to SP3
0
Comment
Question by:anwarcp
  • 6
  • 4
10 Comments
 
LVL 11

Expert Comment

by:bmatumbura
ID: 24096227
I think the SP4 was attempting to stop some SQL service that took too long to terminate. Try to stop the SQL server services manually via the Services applet then try to install SP4
0
 

Author Comment

by:anwarcp
ID: 24096380
i already stop the sql service service, now i am not able start the SQL now
0
 
LVL 11

Expert Comment

by:bmatumbura
ID: 24096481
But have you managed to install the service pack (while the SQL services are stopped)? Rebooting the machine might help
0
 

Accepted Solution

by:
anwarcp earned 0 total points
ID: 24096721
irebooted the system also , while installing the SQL SP4 i was geting
A Service control operation failed for the MS SQLSERVER service 1460
This operation returned because the timeout period expired

This error, now i can not start the SQL service also, when i stat the SQL service i am getting this error
"Could not start the MSSQLSERVER service on Local Computer. Error 1067 the process terminated unexpectedly
0
 

Author Comment

by:anwarcp
ID: 24096888
now i need to start the system, users are waiting for me please help me get start the system
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 11

Expert Comment

by:bmatumbura
ID: 24097064
0
 

Author Comment

by:anwarcp
ID: 24097548
this also did not work, did u have any other option
0
 

Author Comment

by:anwarcp
ID: 24097674
Please find log installation file

08:27:18 Begin Setup
08:27:18 Version on Media: 8.00.2039
08:27:18 Mode = Normal
08:27:18 ModeType = NORMAL
08:27:18 Loading library - sqlsut.dll (#L1)
08:27:18 Begin: SetupInitialize()
08:27:18 End: SetupInitialize()
08:27:18 Begin:  CheckFixedRequirements()
08:27:18 Platform ID: 0xf00
08:27:18 Version: 5.2.3790
08:27:18 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.4392
08:27:18 End:  CheckFixedRequirements()
08:27:18 Begin Action:  CheckRequirements
08:27:18 Processor Architecture: x86 (Pentium)
08:27:18 Service Pack:  512
08:27:18 ComputerName: AFSDEV
08:27:18 User Name: ACP6851
08:27:18 IsAllAccessAllowed returned: 1
08:27:18 OS Language: 0x409
08:27:18 End Action CheckRequirements
08:27:18 CreateSetupTopology(AFSDEV), Handle : 0x1614b28, returned : 0
08:27:18 CreateSetupTopology returned : 0, Handle : 0x1614b28
08:27:18 Topology Type : 1, Return Value : 0
08:27:18 ST_GetPhysicalNode returned : 0, PNHandle : 0x1614b48
08:27:18 PN_EnumerateEx returned : 0
08:27:18 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
08:27:18 PN_StartScan [0x1614b48] returned : 0
08:27:18 PN_GetNext [0x1614b48] returned : 0, Handle: [0x16150d0]
08:27:18 SQLI_GetPackageId [0x16150d0] returned : 0, PackageId = 0x2
08:27:18 SQLI_GetVersion [0x16150d0] returned : 0, Version = 8.00.194
08:27:18 PN_GetNext [0x1614b48] returned : 18, Handle: [0x0]
08:27:18 ReleaseSetupTopology
08:27:18 This combination of Package and Operating System allows a full product install.
08:27:18 Begin:  SetupInstall()
08:27:18 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
08:27:18 CommonFilesDir=C:\Program Files\Common Files
08:27:18 Windows Directory=C:\WINDOWS\
08:27:18 Program Files=C:\Program Files\
08:27:18 TEMPDIR=c:\Temp\1\
08:27:18 End:  SetupInstall()
08:27:18 Begin:  ShowDialogs()
08:27:18 Initial Dialog Mask: 0x8300037, Disable Back=0x1
08:27:18 Begin Action ShowDialogsHlpr: 0x1
08:27:18 Begin Action:  DialogShowSdWelcome
08:27:20 End Action  DialogShowSdWelcome
08:27:20 Dialog 0x1 returned: 1
08:27:20 End Action ShowDialogsHlpr
08:27:20 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
08:27:20 Begin Action ShowDialogsHlpr: 0x2
08:27:20 Begin Action:  DialogShowSdMachineName
08:27:20 ShowDlgMachine returned: 1
08:27:20 Name = AFSDEV, Type = 0x1
08:27:20 End Action  DialogShowSdMachineName
08:27:20 begin ShowDialogsUpdateMask
08:27:20 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
08:27:20 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
08:27:20 Dialog 0x2 returned: 0
08:27:20 End Action ShowDialogsHlpr
08:27:20 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
08:27:20 Begin Action ShowDialogsHlpr: 0x4
08:27:20 Begin Action:  DialogShowSdInstallMode
08:27:20 ShowDlgInstallMode returned: 1
08:27:20 InstallMode : 0x2
08:27:20 End Action  DialogShowSdInstallMode
08:27:20 begin ShowDialogsUpdateMask
08:27:20 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
08:27:20 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
08:27:20 Dialog 0x4 returned: 1
08:27:20 End Action ShowDialogsHlpr
08:27:20 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
08:27:20 Begin Action ShowDialogsHlpr: 0x20
08:27:20 Begin Action:  DialogShowSdLicense
08:27:21 End Action DialogShowSdLicense
08:27:21 Dialog 0x20 returned: 1
08:27:21 End Action ShowDialogsHlpr
08:27:21 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
08:27:21 Begin Action ShowDialogsHlpr: 0x200
08:27:21 Begin Action:  DialogShowSdInstanceName
08:27:21 Begin Action: ShowDlgInstanceName
08:27:22 This machine has SQL Server 2000 SP3 already installed
08:27:22 Version of installed Service Pack: 8.00.761
08:27:22 The language on the CD is 1033 and installed is 1033
08:27:22 End Action : Verify Language
08:27:22 SKU is : Standard Edition
08:27:22 End Action: ShowDlgInstanceName
08:27:22 ShowDlgInstanceName returned : 0
08:27:22 InstanceName : MSSQLSERVER
08:27:22 End Action  DialogShowSdInstanceName
08:27:22 begin ShowDialogsUpdateMask
08:27:22 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
08:27:22 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
08:27:22 Dialog 0x200 returned: 0
08:27:22 End Action ShowDialogsHlpr
08:27:22 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
08:27:22 Begin Action ShowDialogsHlpr: 0x400
08:27:22 Begin Action:  DialogShowSdMaintain
08:27:22 ShowDlgMaintainInstall returned : 1
08:27:22 Type : 0xc
08:27:22 CreateSetupTopology(AFSDEV), Handle : 0x1614b28, returned : 0
08:27:22 CreateSetupTopology returned : 0, Handle : 0x1614b28
08:27:22 Topology Type : 1, Return Value : 0
08:27:22 ST_GetPhysicalNode returned : 0, PNHandle : 0x1614b48
08:27:22 PN_EnumerateEx returned : 0
08:27:22 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
08:27:22 PN_GetInstance for MSSQLSERVER [0x1614b48] returned : 0
08:27:22 SQLI_GetPackageId [0x16150d0] returned : 0, PackageId = 0x2
08:27:22 SQLI_GetVersion [0x16150d0] returned : 0, Version = 8.00.194
08:27:22 SQLI_GetSQLStates for MSSQLSERVER [0x16150d0] returned : 0, SQLStates: 0xc00205
08:27:22 SQLI_GetInstallPath [0x16150d0] returned : 0, Path = d:\Program Files\Microsoft SQL Server\MSSQL
08:27:22 SQLI_GetDataPath [0x16150d0] returned : 0, DataPath = d:\data\sqlsys\MSSQL
08:27:22 SQLI_GetVersion [0x16150d0] returned : 0, Version = 8.00.194
08:27:22 SQLI_GetRegKeyRoot [0x16150d0] returned : 0, RegKeyRoot = Software\Microsoft\MSSQLServer
08:27:22 SQLI_GetPackageName [0x16150d0] returned : 0, szPackage = Standard Edition
08:27:22 SQLI_GetPackageId [0x16150d0] returned : 0, PackageId = 0x2
08:27:22 Previous Install Path:    d:\Program Files\Microsoft SQL Server\MSSQL
08:27:22 Previous Install Data:    d:\data\sqlsys\MSSQL
08:27:22 Previous Install Version: 8.00.194
08:27:22 ReleaseSetupTopology
08:27:22 End Action  DialogShowSdMaintain
08:27:22 begin ShowDialogsUpdateMask
08:27:22 nFullMask = 0xbc00627, nCurrent = 0x400, nDirection = 1
08:27:22 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
08:27:22 Dialog 0x400 returned: 1
08:27:22 End Action ShowDialogsHlpr
08:27:22 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
08:27:22 Begin Action ShowDialogsHlpr: 0x2000
08:27:22 Begin Action:  DialogShowSdUpgrade
08:27:22 ShowDlgUpgrade returned : 1
08:27:22 Checking databases on instance 'MSSQLSERVER'
08:27:22 Authenticate access
08:27:22 Begin SDPassword Dialog
08:27:23 End SDPassword Dialog
08:27:23 c:\Temp\1\SqlSetup\Bin\scm.exe  -Silent 1 -Action 6 -Service MSSQLSERVER  
08:27:23 Process Exit Code: (0)
08:27:23 c:\Temp\1\SqlSetup\Bin\scm.exe  -Silent 1 -Action 1 -Service MSSQLSERVER   -StartupOptions \-T4022
08:42:29 Process Exit Code: (1460) This operation returned because the timeout period expired.

08:42:39 A service control operation failed for the MSSQLSERVER service: 1460
This operation returned because the timeout period expired.

08:44:13 Setup was unable to verify the state of the server for an upgrade.  Verify the server is able to start and that you provided a valid sa password and restart setup.
08:44:13 End Action DialogShowSdUpgrade
08:44:13 End: ShowDialogs()
08:44:13 Action CleanUpInstall:
08:44:13 Installation Failed.
0
 
LVL 11

Expert Comment

by:bmatumbura
ID: 24097855
0
 

Author Comment

by:anwarcp
ID: 24105396
Thanks for you support,
this also did not help me, what i did , i removed the SQL server 2000 and reinstalled the SQL server 2000, then i update SP 4, now it is working
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DIR issue 7 50
SCCM Microsoft Report 2 48
SLMGR Switches Are Not Working On KMS Host 3 67
Can’t delete a file 14 138
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now