Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Installation of SQL 2000

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
  • 2
1 Solution
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
Start here


The search something like "Setup Install script"

Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
Also search MS SQL 20 Books Online for "Unattended"
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.
ldienoAuthor Commented:
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

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.

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