Installation of SQL 2000

Posted on 2004-11-02
Last Modified: 2012-05-05
Hi everyone,

I am not really a SQL or DB Admin... But I am working on setting up a custom, silent install of SQL 2000 for deployment. I have been researching and have found that you need to set up a config file of sorts for the installation (like an answer file).. But I am not sure how to put this into use.

Here are my installation procedures of SQL 2000:

1. Install Database Server
2. New Instance of Database Server is installed on LOCAL workstation
3. Create new Instance of SQL Server
4. Name and Company Info is entered
5. Install Server and Client Tools
6. Accept default Instance Name
7. Custom Install
8. Change Data Files location to custom Directory
9. Accept defaults (all components and sub-components should be installed)
10. The service needs to run under a specific username
11. Blank Password (not reccomended, but currently what we are doing)
12. Change Collation Settings to "Binary Order, for use with the 850 (Multilingual) Character Set"
13. Accept defaults for named pipes and tcp/ip sockets
14. Select “Processor License for” and set the number processors to “1”.
15. Finish installation

I am going to continue to research setting up the answer file, but I thought it would be a good idea to post here as this is where the experts are!

- L
Question by:ldieno
    LVL 4

    Expert Comment

    Start here

    The search something like "Setup Install script"

    LVL 4

    Expert Comment

    Also search MS SQL 20 Books Online for "Unattended"
    LVL 6

    Accepted Solution

    Here's the procedure from bol

    How to run an unattended installation of SQL Server 2000 (Command Prompt)
    You can run an unattended installation by using sample batch files and setup initialization files included on the Microsoft® SQL Server™ 2000 compact disc. Or, you can run the Setup program directly from the command prompt in the appropriate directory for the edition of SQL Server you want to install, using arguments as needed.

    To run an unattended installation using ready-made batch files

    Locate the .bat and .iss files in the root directory of your SQL Server 2000 compact disc.

    View the .bat and associated .iss files, and modify if necessary. For more information, see Creating a Specialized Setup File.

    Run the appropriate batch and setup files from the command prompt:
    For a standard unattended installation, run Sqlins.bat.

    For a client-only unattended installation, run Sqlcli.bat.

    For a custom unattended installation, run Sqlcst.bat.
    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.

    See Also

    Performing an Unattended Installation

    How to record an unattended installation file (Setup)

    ©1988-2004 Microsoft Corporation. All Rights Reserved.

    Author Comment

    thank you for your comments. i was able to figure out how to create an .iss file and do a silent SQL 2000 install. But the issue I am having is with SQL2k SP3 patch... It comes with standard .iss files - but i have never used them.. anyone have any ideas or have used this method before for applying this patch??

    - L

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    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.

    746 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

    13 Experts available now in Live!

    Get 1:1 Help Now