[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2005-04-06
Medium Priority
Last Modified: 2008-01-09


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?

Question by:ibost
  • 2
  • 2
LVL 27

Expert Comment

ID: 13717292
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.

LVL 10

Author Comment

ID: 13718925
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.  
LVL 10

Author Comment

ID: 13727292
I found that using an IPAK to install sql and sp3 at the same time works.
LVL 27

Expert Comment

ID: 13727581
Interesting. Using IPAK the dialog box does not appear and you can do unattended installs. Good to know.

Accepted Solution

ee_ai_construct earned 0 total points
ID: 13757892
Question answered by asker or dialog deemed valuable.
Closed, 125 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question