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
Solved

MS SQL 2000

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lync 2013 deployment on single server 1 65
SCCM Microsoft Report 2 79
Added a column screws up code 5 63
how to loop through and process two columns in excel 8 22
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

840 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