SQL SP4 Uninstended Install failure
-
Using a sql2kdef.iss file the install is stopping.
System is a Windows 2003 server, SQL 2000, with Service Pack 3.
My log excerpt follow
10:54:38 Checking databases on instance 'MSSQLSERVER'
10:54:38 Authenticate access
10:54:38 Begin SDPassword Dialog
10:54:38 C:\DOCUME~1\ADMINI~1.ECO\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 6 -Service MSSQLSERVER
10:54:38 Process Exit Code: (0)
10:54:39 C:\DOCUME~1\ADMINI~1.ECO\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022
10:55:11 Process Exit Code: (0)
10:55:11 \x86\BINN\osql.exe -Slpc:QA -n -d master -Q "exit" -o "C:\DOCUME~1\ADMINI~1.ECO\LOCALS~1\Temp\sqlsp.out" -E
10:55:13 Process Exit Code: (0)
10:55:13 Begin: CheckSAPassword
10:55:13 Begin: LogOnUsingBlankSA
10:55:13 \x86\BINN\osql.exe -Slpc:QAJEFF -n -d master -o "C:\DOCUME~1\ADMINI~1.ECO\LOCALS~1\Temp\sqlsp.out" -Q"Exit(declare @ret int if (select count(*) from master..syslogins where name='sa' AND ( (1 = pwd
10:55:14 Process Exit Code: (0)
10:55:14 End: LogOnUsingBlankSA
10:55:14 SECURITY WARNING : You may have an insecure password for SA login.
10:55:14 Begin : SdErrorReportingDlg
The only thing I could think of was it's failing the password check and reporting a weak password for the SA account. Now I did verify that the passwords on this mixed mode server are complex so I don't think that's the issue but I'm at a loss.
My sql2kdek.iss file follows
[InstallShield Silent]
Version=v5.00.000
File=Response File
[File Transfer]
OverwriteReadOnly=NoToAll
[DlgOrder]
Dlg0=DlgW2kReboot-0
Count=16
Dlg1=SdWelcome-0
Dlg2=DlgMachine-0
Dlg3=DlgInstallMode-0
Dlg4=SdLicense-0
Dlg5=DlgInstanceName-0
Dlg6=DlgMaintainInstall-0
Dlg7=DlgUpgrade-0
Dlg8=ServerConnect-0
Dlg9=SdBlankPwdWarningDlg-0
Dlg10=SdSP3WrngDlg-0
Dlg11=SdErrorReportingDlg-0
Dlg12=DlgCollation-0
Dlg13=DlgServerNetwork-0
Dlg14=SdStartCopy-0
Dlg15=SdFinishReboot-0
[DlgW2kReboot-0]
Result=189
[SdWelcome-0]
Result=1
[DlgMachine-0]
Type=1
Result=1
[DlgInstallMode-0]
Type=2
Result=1
[SdLicense-0]
Result=1
[DlgInstanceName-0]
InstanceName=MSSQLSERVER
Result=0
[DlgMaintainInstall-0]
Type=12
Result=1
[DlgUpgrade-0]
Result=1
[ServerConnect-0]
NTAuthentication=1
SQLAuthentication=0
Result=1
[SdBlankPwdWarningDlg-0]
AllowBlank=0
EnterPwd=' '
ConfirmPwd=' '
Result=0
[SdSP3WrngDlg-0]
EnableCrossDBChaining=0
UpgradeMSSearch=1
MSXTSXUpgraded=0
Result=1
[SdErrorReportingDlg-0]
EnableErrorReporting=0
Result=0
[DlgCollation-0]
collation_name=SQL_Latin1_General_CP1_CI_AS
Result=1
[DlgServerNetwork-0]
NetworkLibs=255
TCPPort=1433
TCPPrxy=Default
NMPPipeName=\\.\pipe\sql\query
Result=1
[SdStartCopy-0]
Result=1
[Application]
Name=Microsoft SQL Server
Version=8.00.000
Company=Microsoft
Lang=0009
[SdFinishReboot-0]
Result=1
BootOption=0
Any help would be appreciated.
-
Apparently there is some issue with MS scenarios involving installing RTM > SP4 versus SP3>SP4.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply