How do I install SQL Server 6.5?
March 4, 1999
A. SQL Server 6.5 can be installed on NT Server 3.51 or NTWorkstation 3.51 or above however if you install on a Workstation you will belimited to the number of concurrent connections and should only really use as adevelopment box.
Before installing the software you should create a SQL Executive accountthat will be used to run the various SQL services
Start User Manager for Domain (Start - Programs - Administrative Tools -User Manager for Domains)
Select "New User" from the User menu
Enter a name of SQLExecAct and a Description of "SQL ExecutiveAccount". Uncheck the "User Must Change Password at Next Logon"and check "User Cannot Change Password" and "Password NeverExpires". Leave the password blank
Click the Groups button and add the Administrators group. Click OK
Click the Add button then click Close
Select "User Rights" from the Policies menu
Check the "Show Advanced User Rights"
Select "Log on as a service" and click Add
Select SQLExecAct and click Add. Click OK
Click OK to close the main User Rights dialog box
Close User Manager for Domains
Click here to view image
- Example of the SQL Executive Account
Once the account has been created you can start the actual SQL 6.5installation
Login as an Administrator on the machine
Insert the SQL installation CD-ROM
Move the the I386 directory of the SQL directory
Double click on SETUP.EXE which will start the installation procedure
Click Continue to the welcome dialog box
Enter your name, company and Product ID. Click Continue
Click Continue to the display dialog showing the information just entered.
Check the "Install SQL Server and Utilities" and click Continue
Choose your licensing mode and click Continue
Check the installation drive and directory is correct and click Continue
Chose your Master device drive and location. This is used to store severalcritical system database's. Click Continue
Select the books option and click Continue
Choose the Installation options for Character Sets, Sort order etc. byclicking the relevant button. Once complete click Continue. Common characterset is "ISO Character Set". You can also select for the SQL serviceand SQL Executive Service to automatically start at bootup time. This can bechanged at a later date.
Choose the SQL Executive Account (the one created) and click Continue(leave password blank)
The installation will then continue without asking more questions (this maytake up to 10 minutes depending on your hardware)
At the end click the "Exit to Windows NT" button
You now have an SQL Server, now how do you use it? :-)
About the Author
You May Also Like