SP3a Installation Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SP3a Installation Problem

Author

Topic

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-06-30 : 05:10:29

[SQLServer Standard Edition,sp2 on Windows 2000 server]
Hi Everyone,
When i try to Install SP3a on a Default Instance iam getting this error:

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.

I have provided the Valid SA password.

I guess that osql cant able to verify/validate the server?maybe have to install lastest MDAC?

thanks in advance

Cindy

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-06-30 : 11:33:42

I googled your error message and found this

http://support.microsoft.com/?kbid=814844

-ec

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-06-30 : 20:15:49

Hi EC,
Thanks for your reply. I have already checked this. The Registry and Variable Settings are Fine.

This what in installation file SQLsp.log

18:14:22 Begin Setup
18:14:22 Version on Media: 8.00.761
18:14:22 Mode = Normal
18:14:22 ModeType = NORMAL
18:14:22 Begin: SetupInitialize()
18:14:22 End: SetupInitialize()
18:14:22 Begin: CheckFixedRequirements()
18:14:22 Platform ID: 0xf00
18:14:22 Version: 5.0.2195
18:14:22 File Version - C:\WINNT\...
18:14:22 End: CheckFixedRequirements()
18:14:22 Begin Action: CheckRequirements
18:14:22 Processor Architecture: x86 (Pentium)
18:14:22 Service Pack: 1024
18:14:22 ComputerName: xxxxx
18:14:23 User Name: xxxx
18:14:23 IsAllAccessAllowed returned: 1
18:14:23 OS Language: 0xc09
18:14:23 End Action CheckRequirements
18:14:23 CreateSetupTopology(xxxxx), Handle : 0x18d4480, returned : 0
18:14:23 CreateSetupTopology returned : 0, Handle : 0x18d4480
18:14:23 Topology Type : 1, Return Value : 0
18:14:23 ST_GetPhysicalNode returned : 0, PNHandle : 0x18d44a8
18:14:23 PN_EnumerateEx returned : 0
18:14:23 PN_GetSQLStates returned : 0, SqlStates : 0x88028225
18:14:23 PN_StartScan [0x18d44a8] returned : 0
18:14:23 PN_GetNext [0x18d44a8] returned : 0, Handle: [0x18d4a38]
18:14:23 SQLI_GetPackageId [0x18d4a38] returned : 0, PackageId = 0x2
18:14:23 SQLI_GetVersion [0x18d4a38] returned : 0, Version = 8.00.194
18:14:23 PN_GetNext [0x18d44a8] returned : 0, Handle: [0x18d53e8]
18:14:23 PN_GetNext [0x18d44a8] returned : 18, Handle: [0x0]
18:14:23 ReleaseSetupTopology
18:14:23 This combination of Package and Operating System allows a full product install.
18:14:23 Begin: SetupInstall()
18:14:23 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
18:14:23 CommonFilesDir=x:\xxxxx
18:14:23 Windows Directory=x:\xxx
18:14:23 Program Files=x:xxxxx
18:14:23 TEMPDIR=C:\DOS18:14:23 End: SetupInstall()
18:14:23 Begin: ShowDialogs()
18:14:23 Initial Dialog Mask: 0x8300037, Disable Back=0x1
18:14:23 Begin Action ShowDialogsHlpr: 0x1
18:14:23 Begin Action: DialogShowSdWelcome
18:15:24 End Action DialogShowSdWelcome
18:15:24 Dialog 0x1 returned: 1
18:15:24 End Action ShowDialogsHlpr
18:15:24 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
18:15:24 Begin Action ShowDialogsHlpr: 0x2
18:15:24 Begin Action: DialogShowSdMachineName
18:15:24 ShowDlgMachine returned: 1
18:15:24 Name = xxxxx, Type = 0x1
18:15:24 End Action DialogShowSdMachineName
18:15:24 begin ShowDialogsUpdateMask
18:15:24 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
18:15:24 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
18:15:24 Dialog 0x2 returned: 0
18:15:24 End Action ShowDialogsHlpr
18:15:24 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
18:15:24 Begin Action ShowDialogsHlpr: 0x4
18:15:24 Begin Action: DialogShowSdInstallMode
18:15:24 ShowDlgInstallMode returned: 1
18:15:24 InstallMode : 0x2
18:15:24 End Action DialogShowSdInstallMode
18:15:24 begin ShowDialogsUpdateMask
18:15:24 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
18:15:24 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
18:15:24 Dialog 0x4 returned: 1
18:15:24 End Action ShowDialogsHlpr
18:15:24 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
18:15:24 Begin Action ShowDialogsHlpr: 0x20
18:15:24 Begin Action: DialogShowSdLicense
18:15:27 End Action DialogShowSdLicense
18:15:27 Dialog 0x20 returned: 1
18:15:27 End Action ShowDialogsHlpr
18:15:27 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
18:15:27 Begin Action ShowDialogsHlpr: 0x200
18:15:27 Begin Action: DialogShowSdInstanceName
18:15:27 Begin Action: ShowDlgInstanceName
18:15:37 This machine has SQL Server 2000 SP2 already installed
18:15:37 Version of installed Service Pack: 8.00.534
18:15:37 The language on the CD is 1033 and installed is 1033
18:15:37 End Action : Verify Language
18:15:37 SKU is : Standard Edition
18:15:37 End Action: ShowDlgInstanceName
18:15:37 ShowDlgInstanceName returned : 0
18:15:37 InstanceName : MSSQLSERVER
18:15:37 End Action DialogShowSdInstanceName
18:15:37 begin ShowDialogsUpdateMask
18:15:37 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
18:15:37 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
18:15:37 Dialog 0x200 returned: 0
18:15:37 End Action ShowDialogsHlpr
18:15:37 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
18:15:37 Begin Action ShowDialogsHlpr: 0x400
18:15:37 Begin Action: DialogShowSdMaintain
18:15:37 ShowDlgMaintainInstall returned : 1
18:15:37 Type : 0xc
18:15:37 CreateSetupTopology(xxxxx), Handle : 0x18d5cf0, returned : 0
18:15:37 CreateSetupTopology returned : 0, Handle : 0x18d5cf0
18:15:37 Topology Type : 1, Return Value : 0
18:15:37 ST_GetPhysicalNode returned : 0, PNHandle : 0x18d4480
18:15:37 PN_EnumerateEx returned : 0
18:15:37 PN_GetSQLStates returned : 0, SqlStates : 0x88028225
18:15:37 PN_GetInstance for MSSQLSERVER [0x18d4480] returned : 0
18:15:37 SQLI_GetPackageId [0x18d6678] returned : 0, PackageId = 0x2
18:15:37 SQLI_GetVersion [0x18d6678] returned : 0, Version = 8.00.194
18:15:37 SQLI_GetSQLStates for MSSQLSERVER [0x18d6678] returned : 0, SQLStates: 0xc00205
18:15:37 SQLI_GetInstallPath [0x18d6678] returned : 0, Path = x:\Program Files18:15:37 SQLI_GetDataPath [0x18d6678] returned : 0, DataPath = x:\Program Files18:15:37 SQLI_GetVersion [0x18d6678] returned : 0, Version = 8.00.194
18:15:37 SQLI_GetRegKeyRoot [0x18d6678] returned : 0, RegKeyRoot = xxxx
18:15:37 SQLI_GetPackageName [0x18d6678] returned : 0, szPackage = Standard Edition
18:15:37 SQLI_GetPackageId [0x18d6678] returned : 0, PackageId = 0x2
18:15:37 Previous Install Path: x:\Program Files\Microsoft SQL Server\MSSQL
18:15:37 Previous Install Data: x:\Program Files\Microsoft SQL Server\MSSQL
18:15:37 Previous Install Version: 8.00.194
18:15:37 ReleaseSetupTopology
18:15:37 End Action DialogShowSdMaintain
18:15:37 begin ShowDialogsUpdateMask
18:15:37 nFullMask = 0xbc00627, nCurrent = 0x400, nDirection = 1
18:15:37 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
18:15:37 Dialog 0x400 returned: 1
18:15:37 End Action ShowDialogsHlpr
18:15:37 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
18:15:37 Begin Action ShowDialogsHlpr: 0x2000
18:15:37 Begin Action: DialogShowSdUpgrade
18:15:37 ShowDlgUpgrade returned : 1
18:15:37 Checking databases on instance 'MSSQLSERVER'
18:15:37 Authenticate access
18:15:37 Begin SDPassword Dialog
18:16:03 End SDPassword Dialog
18:16:03 C:\DOS\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQLSERVER
18:16:03 Process Exit Code: (0)
18:16:03 C:\DOS\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4010 \-T4022 \-m
18:16:33 Process Exit Code: (1053) The service did not respond to the start or control request in a timely fashion.

18:16:42 A service control operation failed for the MSSQLSERVER service: 1053
The service did not respond to the start or control request in a timely fashion.

18:16:43 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.
18:16:43 End Action DialogShowSdUpgrade
18:16:43 End: ShowDialogs()
18:16:43 Action CleanUpInstall:
18:16:43 Installation Failed.

Cindy

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-30 : 20:44:53

Have you tried restarting the installation since you got this error? Also, you might want to set the sa password to blank and try it that way.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-06-30 : 21:04:27

I forgot to mention, i have another instance(sql 2000) running on the same server, i installed sp3a on that one.
Does it affect the sp3a installation in any way?

I restarted the server twice but I will try with Blank SA password.

thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-07-01 : 01:52:59

I can think of a couple of other things to check:

1. I had a problem with installing a service pack and it was caused by an alias that was in place on the server. Check the SQL client network util (cliconfg from the run command) on this box to see if you have a named pipes alias setup for this instance. If you do, get rid of it and try the upgrade again.

2. Check to see if the user configured to start the MSSQLSERVER service is still valid on the machine. Does it match the user from the other instance you are running? Is this user a local admin?

Looking at the logfile you posted it appears that you are able to successfully down the instance, but starting it fails. Here is a similar error (1053) but it is specific to SQL Agent. Maybe it pertains to your situation somehow. http://support.microsoft.com/default.aspx?scid=kb;en-us;322140&Product=sql2k

-ec

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-07-01 : 21:03:53

Ok Tried yesterday with Blank SA password but still same error.
EC, have checked everything with the instance of the server.
there is no Alias in the Clicnfg.

But everything is same except the Server Network Utility.
Named Pipes is enabled in default and disabled in NamedInstance

Will try to disable it and try to install

thanks guys
Cindy

t_eklund
Starting Member

1 Post

Posted - 2004-07-09 : 13:47:42

I was having the same problem and was able to successfully install SP3a by doing the following.

-- Change MSSQL Server service to start manually
-- Change Distributed Transaction Coordinator service to start manually.
-- Reboot the server
-- Run the SQL Server SP3a installation program (I received an error when logging into the service, but the installation continued without a problem. The error said something about the server not being started. I beleive it was just a timing issue)
-- Change the MSSQL Server service and Distributed Transaction Coordinator services back to "Automatic" startup.
-- Reboot server

Hopefully this works for you the same as it did for me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources