?
Solved

MS SQL 2000

Posted on 2009-04-08
10
Medium Priority
?
483 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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
 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
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…
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…
Suggested Courses

649 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