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

Posted on 2005-04-06
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
    LVL 27

    Expert Comment

    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

    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

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

    Expert Comment

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

    Accepted Solution

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

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now