Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

MS SQL 2000

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
anwarcp
Asked:
anwarcp
  • 6
  • 4
1 Solution
 
bmatumburaCommented:
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
 
anwarcpAuthor Commented:
i already stop the sql service service, now i am not able start the SQL now
0
 
bmatumburaCommented:
But have you managed to install the service pack (while the SQL services are stopped)? Rebooting the machine might help
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
anwarcpAuthor Commented:
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
 
anwarcpAuthor Commented:
now i need to start the system, users are waiting for me please help me get start the system
0
 
anwarcpAuthor Commented:
this also did not work, did u have any other option
0
 
anwarcpAuthor Commented:
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
 
anwarcpAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now