Installation Guide on SQL Service Pack 3

•After the installation of the SQL 2000 Enterprise Server, it is required to install the Service Pack from Microsoft. Included in the service pack are patches and improvements on the SQL 2000 server security.

•Using the Windows Explorer, go to the “sql2ksp3” folder.

•Note: It is assumed that the account you are login is the “Administrator” account of the Windows 2000 Advance Server. Administrator account is needed to install any software in windows 2000 Advance Server.

1. From the Windows Explorer, double click file “setup.bat” or left click file “setup.bat” and press enter on the keyboard.

2. From Welcome window, click Next button. Software License Agreement window appears.

3. Read the agreement, then click Yes button to accept.

4. From Instance Name window, just click Next button. Connect to Server window appears.

5. Choose The Windows account information I use to log on to my computer with (Windows authentication) option button. Then click Next button to continue.

6. MS SQL validating the account.

7. SQL Server 2000 Service Pack 3 Setup window appears. Just click Continue button to proceed.

8. Error Reporting window appears. Just click OK button to continue.

9. MS SQL 2000 gathers and processes information.

10. Click Next button to continue.

11. Setup installing MDAC.

12. Setup updating MS SQL 2000.

13. Running script

14. Click OK button. 15. Click Finish button.

15. Click Finish button.

Installation Guide on SQL 2000 Enterprise

•After you have located the setup file (AUTORUN.EXE) on the CD under the “ENT” folder in the windows explorer. Let’s continue on page 2, for the step-by-step installation of the SQL 2000 Enterprise Server.

•Note: After the installation the installation of SQL 2000 Enterprise. Install SQL service pack 3 or the latest service pack from Microsoft, to avoid hacks & virus/worms, for security purposes.

Requirements:

Hardware Minimum requirements

–Computer Intel® or compatible
–Pentium 166 MHz or higher.
–Memory (RAM)

Enterprise Edition: 64 MB minimum, 128 MB or more
recommended
Hard disk space
-SQL Server database components: 95 to 270 MB,
250 MB typical
–CD-ROM drive (Required)

• Additional memory may be required, depending on operating system requirements.

• Actual requirements will vary based on your system configuration and the applications and features you choose to install.

• Operating SystemWindows 2000 Advance Server

1. Double click on the AUTORUN.EXE file, to start the SQL 2000 Enterprise installation, under the “ENT” folder in “SQL2000”.

2. When the SQL 2000 Enterprise Server setup program starts, this window opens. Point and click on the SQL Server 2000 Components. Install Components window will be displayed.

3. Point and click Install Database Server. A progress bar will pop-out, to initialize the SQL 2000 installation then closed. Welcome Installation Wizard will be opened.

4. Click Next button to continue.

5. Select Local Computer option button then click Next button.

6. Select Create a new instance of SQL Server, or install Client Tools option button. Then click Next button to continue.

7. Enter the customer name (your company name) in the Name field, the company name in the Company field. Click Next button.

8. Software License Agreement window opens. Read the License Agreement then click Yes button. Installation Definition window appears.

9. Select Server and Client Tools option button. Click Next button, to open Instance Name window.

10. From Instance Name window, click Default checkbox. Then click Next button to go to Setup Type window.

11. (1) Click Custom option button.

(2) Choose the preferred disk for Program Files and Data Files.

(3) Click Browse button.

12. Choose the drive with large free disk space. Then create folder “SQLData”, then click OK button and go back to Setup Type window.

13. Click Next button to proceed to Select Components window.

14. Leave default setting for Components and Sub-components. Just click Next button to continue.

15. (1) Click Use the same account for each service. Auto start SQL Server Service option.

(2) Click Use the Local System account option button under Service Settings.

(3) Click Next button to continue.

16. The Authentication Mode window appears.

17. (1) Choose Mixed Mode (Windows Authentication and SQL Server Authentication) option button.

(2) SQL provides an “sa” (system administrator) login account, it is recommended that you provide a password (accepts alphanumeric). Memorize the password, you will use it later on to access sql 2000.

(3) Click “Next”

18. Just click Next button to continue.

19. (1) Click Named Pipes checkbox. Leave default in the Named Pipe Name field.

(2) Click TCP/IP Sockets checkbox. Leave default in the Port number field.

(3) Click Next button and continue.

20. Click Next button. Choose Licensing Mode window appears.

21. (1) Click Processors License for option button for Licensing Mode

(2) Type 1 in processors’ textbox.

(3) Click Continue button.

22. Installation in progress.

23. Once the installation is finished, a setup complete window will appear

24. This window means that the installation is in progress.

25. When the installation of SQL Server 2000 is complete, the Setup Complete screen appears. Click Finish button to complete setup.

Steps in Setting Up Your Windows 2000 Advance Server - RRAS

ROUTING AND REMOTE ACCESS

1. From Start menu, choose Programs then Administrative Tools. Then click Routing and Remote Access.

2. From Routing and Remote Access window, right click SMARTF (local) server then choose Configure and Enable Routing and Remote Access.

3. Set up wizard will be opened. Click Next button to continue.

4. Click Internet connection server option then click Next button.

5. Choose second option to set up a router with the Network Address Translation (NAT) routing protocol then click Next.

6. Click Use the selected Internet connection option then click Intel as the Internet connection. Click Next button to continue.

7. Click Finish button to complete set up. Routing and Remote Access Server Setup Wizard will be closed.

8. Click X button from the upper right corner of the Routing and Remote Access window to close.

Steps in Setting Up Your Windows 2000 Advance Server - DHCP Installation

D H C P I n s t a l l a t i o n

1. From Start menu, choose Programs then Administrative Tools then click Configure Your Server.

2. Click Networking from the menu.

3. Click DHCP from the Networking options.

4. Click Start button from DHCP window to open Windows Components wizard.

5. Click Networking Services checkbox then click Details button.

6. Check Dynamic Host Configuration Protocol (DHCP) checkbox then click OK button.

7. Click Next button from Windows Components to continue.

8. Click Finish button.

9. Close Windows 2000 Configure Your Server window by clicking X button at the upper right corner of the window.

10. From Start menu click Programs then Administrative Tools then choose DHCP.

11. Click the server icon.

12. Right click the server icon then click New Scope.

13. From New Scope Wizard, click Next button.

14. Type the name and description on the space provided then click Next button.

15. Specify the IP address range and Subnet Mask then click Next button.

16. Specify the IP Address range that you want to exclude in the Start IP and End IP Address then click Add button.

17. Address specified will reflect on the Excluded address range field. Click Next button to continue.

18. Click Next button.

19. In Configure DHCP Options, click the first option to configure DHCP then click Next button.

20. Type the router or default gateways on the IP address field then click Add button.

21. IP address will be transferred on the space below, click Next button to continue.

22. Fill up Parent domain and Server name field (both with smartf). Click Resolve button. IP address will automatically be generated. Click Add button to save then click Next button.

23. IP address will be transferred on the space below, click Next button.

24. Just click Next button to continue.

25. Activate scope by clicking the first option then click Next button.

26. Click Finish button to complete process.

27. Right click server name then choose Authorize. Then press F5 key.

28. Click Scope DHCP folder to open.

29. Click Scope Options folder to view content.

30. Right click 006 DNS Servers then choose Properties from the pop up menu.

31. Click 003 Router and 006 DNS Servers. Highlight Router then enter IP address. Click Add button to save IP Address.

32. Choose 006 DNS Server then type the IP Address. Click Add to save IP for DNS Servers.

33. Type another IP address then click Add button. Click Next button to continue.

34. Click Apply button to save settings.

35. Click OK button to close Scope Options window.

36. Right click Scope Options again then choose Configure Options.

37. Click checkbox 019 IP Layer Forwarding then click Apply button. Click OK button to close window.

38. Click X button at the upper right corner of the DHCP window to close.

Steps in Setting Up Your Active Directory and DNS Server

Active Directory Installation
Requirements

• An NTFS partition with enough free space
• An Administrator's username and password
• l The correct operating system version
• A NIC
• Properly configured TCP/IP (IP address, subnet mask and - optional - default gateway)
• A network connection (to a hub or to another computer via a crossover cable)
• An operational DNS server (which can be installed on the DC itself)
• A Domain name that you want to use
• The Windows 2000 CD media (or at least the i386 folder)
• Brains (recommended, not required...)

Step 1: Configure the computer's suffix

• Right click My Computer and choose Properties.
• Click the Network Identification tab, then Properties.
• Set the computer's NetBIOS name. On a W2K server this cannot be changed after the computer has been promoted to Domain Controller.
• Click More.
• In the Primary DNS suffix of this computer box enter the would-be domain name. We will use sample.edu.ph for this example; you should use your own domain name. Make sure you got it right. No spelling mistakes, no "oh, I thought I did it right..." because on W2K this cannot be changed after the computer has been promoted to Domain Controller and if you got it wrong the Dcpromo process might fail.
• Click Ok.
• You'll get a warning window.
• Click Ok.
• Check your settings. See if they're correct.
• Click Ok.
• You'll get a warning window.
• Click Ok to restart.

Step 2: Configuring the computer's TCP/IP settings

• You must configure the would-be Domain Controller to use its own IP address as the address of the DNS server, so it will point to itself when registering SRV records and when querying the DNS database.

Configure TCP/IP

• Click Start, point to Settings and then click Control Panel.
• Double-click Network and Dial-up Connections.
• Right-click Local Area Connection and then click Properties.
• Click Internet Protocol (TCP/IP), and then click Properties.
• Assign this server a static IP address, subnet mask, and gateway address. Enter the server's IP address in the Preferred DNS server box
• Click Advanced.
• Click the DNS Tab.
• Select "Append primary and connection specific DNS suffixes
• Check "Append parent suffixes of the primary DNS suffix"
• Check "Register this connection's addresses in DNS". If this Windows 2000-based DNS server is on an intranet, it should only point to its own IP address for DNS; do not enter IP addresses for other DNS servers here. If this server needs to resolve names on the Internet, it should have a forwarder configured.
• Click OK to close the Advanced TCP/IP Settings properties.
• Click OK to accept the changes to your TCP/IP configuration.
• Click OK to close the Local Area Connections properties.

Step 3: Install and configure the DNS Service

• The Domain Name System (DNS) is the Active Directory locator in Windows 2000. Active Directory clients and client tools use DNS to locate domain controllers for administration and logon. You must have a DNS server installed and configured for Active Directory and the associated client software to function correctly. This article guides you through the required DNS configuration.

Install Microsoft DNS Server

• Click Start, point to Settings, and then click Control Panel.
• Double-click Add/Remove Programs.
• Click Add and Remove Windows Components.
• The Windows Components Wizard starts. Click Next.
• Click Networking Services, and then click Details.
• Click to select the Domain Name System (DNS) check box, and then click OK.
• Click OK to start server Setup. The DNS server and tool files are copied to your computer.
• Continue to the next step to configure the DNS server.

Configure the DNS Server Using DNS Manage

• Click Start, point to Programs, point to Administrative Tools, and then click DNS Manager. You see two zones under your computer name: Forward Lookup Zone and Reverse Lookup Zone.
• The DNS Server Configuration Wizard starts. Click Next.
• If the Wizard does not auto-start, right-click your server name object in the DNS Manager console and choose Configure your Server.
• Choose to add a forward lookup zone. Click Next. The new forward lookup zone must be a primary zone so that it can accept dynamic updates. Click Primary, and then click Next.
• The zone name must be exactly the same as your Active Directory Domain name, or, if on a stand-alone or workgroup environment - the same as the suffix for all of the network computers that are to register with this DNS server. Type the name of the zone, and then click Next.
• Accept the default name for the new zone file. Click Next.
• Choose to add a reverse lookup zone now. Click Next.
• Click Primary, and then click Next.
• Type the name of the zone, and then click Next. The zone name should match the Network ID of your local subnet. For example, if your subnet range is from 192.168.0.1 to 192.168.0.254, type 192.168.0 in the name value.
• Accept the default name for the new zone file. Click Next.
• Click Finish to complete the Server Configuration Wizard.
• After the Server Configuration Wizard is finished, DNS Manager starts. Proceed to the next step to enable dynamic update on the zone you just added.

Enable Dynamic Update on the Forward and Reverse Lookup Zones (Optional - Recommended)

• In DNS Manager, expand the DNS Server object.
• Expand the Forward Lookup Zones folder.
• Right-click the zone you created, and then click Properties.
• On the General tab, click to select the Allow Dynamic Update check box, and then click OK to accept the change.
• Do the same for the Reverse Lookup Zone.

Enable DNS Forwarding for Internet connections

• Click Start, point to Programs, point to Administrative Tools, and then click DNS to start the DNS Management Console.
• Right click the DNS Server object for your server in the left pane of the console, and click Properties.
• Click the Forwarders tab.
• Check the Enable forwarders check-box.
• In the IP address box enter the IP address of the DNS servers you want to forward queries to - typically the DNS server of your ISP. You can also move them up or down. The one that is highest in the list gets the first try, and if it does not respond within a given time limit - the query will be forwarded to the next server in the list.
• Click OK.

Step 4: Running DCPROMO

• After completing all the previous steps (remember you didn't have to do them) and after double checking your requirements you should now run Dcpromo.exe from the Run command.
• Click Start, point to Run and type "dcpromo".
• The wizard windows will appear. Click Next.
• Choose Domain Controller for a new domain and click Next.
• Choose Create a new domain tree and click Next.
• 
  
• 
  
• Choose Create a new forest of domain trees and click Next.
• Enter the full DNS name of the new domain, for example - dpetri.net - this must be the same as the DNS zone you've created in step 3, and the same as the computer name suffix you've created in step 1. Click Next.
• This step might take some time because the computer is searching for the DNS server and checking to see if any naming conflicts exist.
• Accept the the down-level NetBIOS domain name, in this case it's amalipa. Click Next
• Accept the Database and Log file location dialog box (unless you want to change them of course). The location of the files is by default %systemroot%\NTDS, and you should not change it unless you have performance issues in mind. Click Next.
• Accept the Sysvol folder location dialog box (unless you want to change it of course). The location of the files is by default %systemroot%\SYSVOL, and you should not change it unless you have performance issues in mind. This folder must be on an NTFS v5.0 partition. This folder will hold all the GPO and scripts you'll create, and will be replicated to all other Domain Controllers. Click Next.
• If your DNS server, zone and/or computer name suffix were not configured correctly you will get the following warning:
• This means the Dcpromo wizard could not contact the DNS server, or it did contact it but could not find a zone with the name of the future domain. You should check your settings. Go back to steps 1, 2 and 3. Click Ok.
• You do have an option to let Dcpromo do the configuration for you. If you want, Dcpromo can install the DNS service, create the appropriate zone, configure it to accept dynamic updates, and configure the TCP/IP settings for the DNS server IP address. Click Next.
• Accept the default choice or, if you want, quit Dcpromo and check steps 1-3.
• Accept the Pre-Windows 2000 compatible permissions.
• Enter the Restore Mode administrator's password. You can leave it blank (in Windows Server 2003 you must enter a password) but whatever you do - remember it! Without it you'll have a hard time restoring the AD if you ever need to do so. Click Next.
• Review your settings and if you like what you see - Click Next.
• See the wizard going through the various stages of installing AD. Whatever you do - NEVER click Cancel!!! You'll wreck your computer if you do. If you see you made a mistake and want to undo it, you'd better let the wizard finish and then run it again to undo the AD.
• If all went well you'll see the final confirmation window. Click Finish.
• You must reboot in order for the AD to function properly. Click Restart now.

Step 5: Checking the AD installation

• First, see that the Administrative Tools folder has all the AD management tools installed.
• Run Active Directory Users and Computers (or type "dsa.msc" from the Run command). See that all OUs and Containers are there.
• Run Active Directory Sites and Services. See that you have a site named Default-First-Site-Name, and that in it your server is listed.
• Open the DNS console. See that you have a zone with the same name as your AD domain (the one you've just created, remember? Duh...). See that within it you have the 4 SRV record folders. They must exist.
• This might happen if you did not manually configure your DNS server and let the DCPROMO process do it for you.
• Another reason for the lack of SRV records (and of all other records for that matter) is the fact that you DID configure the DNS server manually, but you made a mistake, either with the computer suffix name or with the IP address of the DNS server (see steps 1 through 3).

Steps in Setting Up Your Windows 2000 Advance Server

Installing Windows 2000 Advance Server:

Hardware Requirements:

• Pentium III 500MHz or Higher / Dual Processor
• 128MB Memory or Higher
• at least 5GB Hard Disk

Software Requirements:

• Windows 2000 Advanced Server CD
• Windows 2000 Service Pack 4 CD or latest patches

System Installation:

1. Make sure that the first boot options are set to CDROM.
2. Insert the Windows 2000 Advanced Server CD, and then PRESS any key to boot from CD.
3. On the Welcome to Setup menu press ENTER.
4. On the Windows 2000 Licensing Agreement press F8.
5. Press C to create a partition and enter the partition size (e.g. 4000MB) then press ENTER, or delete the existing partition before creating new partition.
6. Format the partition using the NTFS file system and press ENTER.
   1. Note: This time boot directly to drive C:
7. At the Regional Settings click NEXT.
8. At the Personalize Your Software type your Name & Organization (e.g. IT, ORG) and click NEXT.
9. At the Licensing Modes select Per seat and click NEXT.
10. Type the computer name, maximum of 8 characters only (e.g. SMART) and then the Administrator password (e.g. smart!) and click NEXT.
11. At the Windows 2000 Components click NEXT.
12. At the Date and Time Settings select the current Date & Time and change the Time Zone to +8 and click NEXT.
13. At the Network Settings just click NEXT.
14. At the Workgroup or Computer Domain just click NEXT.
15. Remove the Windows 2000 Server CD and click FINISH to restart the Server.
16. After you Log On to Windows, Windows 2000 Configure Your Server appears.
17. Select I will configure this server later and click NEXT, remove the check at Show this screen at startup and close the Windows 2000 Configure Your Server dialog box.

Configuring Your Windows 2000 Server:

1. Open Network Dial-up Connection

2. From Network and Dial-up Connections Window, right click Intel icon then click Properties.

3. Click NetBEUI Protocol and Internet Protocol (TCP/IP) checkbox. Then choose TCP/IP and click Properties button.

4. Set the IP address and DNS Server as shown below then click OK button.

5. Click OK button from Intel Properties window to close.

6. Right click 3Com icon from Network and Dial-up Connection window then click Properties.

7. Click TCP/IP Checkbox then click Properties button.

8. Set the IP address and DNS Server as shown below then click OK button.

9. Click OK button from 3Com Properties window to close.

NEXT POST WILL BE: CONFIGURING ACTIVE DIRECTORY