How do I suppress the version warning during an unattended install of SQL Server 2000?



When installing SQL Server 2000, the very first thing that happens after I run setupsql.exe is a warning pops up.

It says:
SQL Server 2000 sp3 and below is not supported by this version of Windows.  Please apply sp4 after installation of SQL Server 2000.

Normally during an "attended" install I just check "don't show me this again" and click Continue.

The problem comes when I try to do an unattended install of SQL, this warning pops up forcing interaction.  How do I suppress that warning so I can have installation be 100% unattended?

LVL 10
Who is Participating?
ee_ai_constructConnect With a Mentor Commented:
Question answered by asker or dialog deemed valuable.
Closed, 125 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
From BOL (unattended installation):

To run an unattended installation directly from the command prompt

Run Setupsql.exe from the Setup directory in the appropriate architecture directory.

Use arguments as needed:
-f1 <initialization file path>
Selects an unattended setup initialization file.

start /wait command (with the -SMS option)
Returns control to the command prompt only after SQL Server Setup completes.

-s flag
Causes the Setup program to run in silent mode with no user interface.
For examples of command prompt options and arguments, see the sample .bat files on your SQL Server 2000 compact disc.

You might also try (also from BOL)

Performing an Unattended Installation
You can perform an unattended installation of Microsoft® SQL Server™ 2000, in which setup screen entries are made automatically using stored information. An unattended installation can be convenient if you want to perform several installations of SQL Server with identical configurations on different computers. An unattended installation requires a setup initialization file, which can be created in several different ways.

By default, each time you install SQL Server using the Setup screens, the options you select are recorded into the setup initialization file, Setup.iss. Setup.iss is placed in the system root directory (%windir%), and is available to provide installation settings at a later time.

Note  You cannot perform an unattended installation to set up a failover cluster of Microsoft SQL Server 2000.

Creating a Setup File Using the Record Unattended Option
In Setup, when you select the Record Unattended .ISS file option in the Advanced Options screen, each subsequent choice you make in the setup screens is recorded in the Setup.iss file stored in the system root directory. SQL Server files are not installed in this process. The Setup.iss file can then be run as is, or revised in a text editor if necessary.

ibostAuthor Commented:
Thanks ptjcb,

Unfortunately everything you have said is what I am already doing.  Perhaps I should have elaborated more:

I did create my .iss file by using the "Record Unattended" option in the Advanced Options screen.  

I call the iss file in this way:

start "installer" /wait "x86\setup\setupsql.exe" -s -f1 SQL2kEnt.iss

The very first thing that happens is a warning dialog pops up (text given in my first post).  My options on this dialog are:
[checkbox] Don't display this message again
[Button] Continue
[Button] Cancel
[Button] Details

If you click "Details" it just takes you to help center message that is the same text ("SQL Server Sp3 and below......")

When I check the box and click continue, the unattended installation proceeds normally.  The problem is that it isn't completely unattended because I have to manually bypass that warning message.  
ibostAuthor Commented:
I found that using an IPAK to install sql and sp3 at the same time works.
Interesting. Using IPAK the dialog box does not appear and you can do unattended installs. Good to know.
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.

All Courses

From novice to tech pro — start learning today.