[Webinar] Streamline your web hosting managementRegister Today

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

Unattended installation of SP3a does not work

Hi,

I am trying to install SP3a onto SQL Server 2000 Enterprise Edition using the unattend .iss file.

My sql server is installed on Windows Server 2003 build 3790.srv03_sp1_rtm.050321-2020 : Service Pack 1

I am copying the sql2kdef.iss file down locally then I execute the following at the command line:

setupsql.exe -s -f1 "c:\sql2kdef.iss" -sapwd <password>

However, after this process exits, I use query analyzer to run "SELECT @@VERSION" and it is still showing as 8.00.194 (the RTM version).  If I do a manual installation, the same query would return 8.00.760 (SP3).  

Why doesn't the unattend work?

Thanks,
Ian
0
ibost
Asked:
ibost
  • 3
1 Solution
 
mcmonapCommented:
Hi ibost,

check the log file for errors:
c:\windows\sqlsp.log
0
 
ibostAuthor Commented:
Thanks mcmonap,

I checked sqlsp.log and couldn't make heads or tails of it.  

However, I think one problem was that the SA password was not set.  I thought the "-sapwd blah" was SETTING the password but that is actually if you want to run the unattended setup using SQL auth (incidentally i am windows mode... not mixed mode).  Later in the sp3readme it says if the SQL Server being upgraded has a blank sa password then one must be set prior to running unattended installation.  

I set it in QA with this, even tho I'm not in mixed mode:  exec sp_password NULL, 'blah', 'sa'

After setting the password I rebooted and retried the install like this:
setupsql.exe -s -f1 "c:\sql2kdef.iss"

Again it failed but now I get a new error in sqlsp.log.  What is the MSSearch and why do I have to upgrade it?  (And how?)
-Ian

10:45:26 Begin: CheckSAPassword
10:45:26 Begin: LogOnUsingBlankSA
10:45:26 \\products\public\products\APPLIC~1\Server\SQL_SE~1\SP3a\x86\BINN\osql.exe  -Slpc:IBOST-VS2 -n -d master -o "C:\DOCUME~1\ibost\LOCALS~1\Temp\sqlsp.out" -Q"Exit(declare @ret int if (select count(*) from master..syslogins where name='sa' AND ( (1 = pwd
10:45:28 Process Exit Code: (0)
10:45:28 End: LogOnUsingBlankSA
10:45:28 WARNING : No Blank SA Pwd
10:45:28 End: CheckSAPassword
10:45:28 Begin: SdShowSp3WrngDlg
10:45:28 \\products\public\products\APPLIC~1\Server\SQL_SE~1\SP3a\x86\BINN\osql.exe  -Slpc:IBOST-VS2 -n -d master -o "C:\DOCUME~1\ibost\LOCALS~1\Temp\sqlsp.out" -Q"Exit(declare @ret int if (select count(*) from msdb.dbo.systargetservers) = 0 Set @ret=0 else Set @ret=403 Select @ret)"  -E
10:45:29 Process Exit Code: (0)
10:45:29 Error : MSSearch requires upgrade. User provided MSSearchUpgrade value caused Setup to abort.
10:45:29 Error : While detecting required SP3 warnings.
10:45:29 End Action DialogShowSdUpgrade
10:45:29 End: ShowDialogs()
10:45:29 Action CleanUpInstall:
10:45:29 Installation Failed.
0
 
ibostAuthor Commented:
Ok now I am trying again with manually going into sql2kdef.iss and setting UpgradeMSSearch to 1.
0
 
ibostAuthor Commented:
It worked.  Thanks for pointing me in the right direction... I was able to figure out what to do by looking at the setup log.
0

Featured Post

Get your problem seen by more experts

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

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