Solved

MS SQL 2000

Posted on 2009-04-08
10
449 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
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.

 

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
 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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…
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

832 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