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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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"
Partha MandayamTechnical DirectorCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.