Step By Step Installation of Sql Server 2008 r2

Sql server installation 

In order for you to begin installing SQL Server on Windows Server 2008 R2

First, add the .NET Framework v3.5.1 that SQL Server  requires.

ACTIVE DOMAIN DIRECTORY CONFIGURATION

Active Domain Directory

1.Server manager is showing that Active Directory Domain Services is still not running. This is because we have not run dcpromo yet.

2. Click on the Start button, type dcpromo.exe in the search box and either hit Enter or click on the search result.

 

 

3. The Active Directory Domain Services Installation Wizard will now start. There are links to more information if you want to learn a bit more you can follow them or you can go ahead and click Use advanced mode installation and then click Next.

 

4. The next screen warns about some operating system compatibility with some older clients.

For more information you can view the support documentation from Microsoft and after you have read through it go ahead and click Next.

 5. Next is the Choose Deployment Configuration screen and you can choose to add a domain to an existing forest or create a forest from scratch. Choose Create a new domain in a new forest and click Next.

6. The Name the Forest Root Domain wants you to name the root domain of the forest you are creating.

For the purposes of this test you can create your own domain. After typing that go ahead and click Next.

7. The wizard will test to see if that name has been used, after a few seconds you will then be asked for the NetBios name for the domain. In this case I will leave the default in place of ADEXAMPLE, and then click Next.

8. The next screen is the Set Forest Functional Level that allows you to choose the function level of the forest.

Since this is a fresh install and a new forest with no additional prior version domains to worry about I am going to select Windows Server 2008. If you did have other domain controllers at earlier versions or had a need to have Windows 2000 or 2003 domain controllers (because of Exchange for example), then you should select the appropriate function level.

Select Windows Server 2008 and then click Next.

9.  Now we come to the Additional Domain Controller Options where you can select to install a DNS server, which is recommended on the first domain controller.

If this was not the first domain controller you would have the options of installing Global Catalog and/or setting this as a Read-only Domain Controller. Since it is the first domain controller, Global Catalog is mandatory, and a RDOC controller is not an available option.

Let’s install the DNS Server by placing a check next to it and clicking Next.

 You will get a warning window about delegation for this DNS server cannot be created, but since this is the first DNS server you can just click Yes and ignore this warning.

10. Next you can choose to place the files that are necessary for Active Directory, including the Database, Log Files, and SYSVOL.

It is recommended to place the log files and database on a separate volume for performance and recoverability. You can just leave the defaults though and click Next.

11. Now choose a password for Directory Services Restore Mode that is different than the domain password. Type your password and confirm it before hitting Next.

Note: You should use a STRONG password for this and will be warned if it doesn’t meet criteria.

 12. Next you will see a summary of all the options you have went through in the wizard.

If you plan on creating more domain controllers with the same settings hit the Export settings … button to save off a txt copy of the settings to use in an answer file for a scripted install. After exporting and reviewing settings click on Next.

13. ow the installation will start including the DNS server option if selected. You will notice a box to Reboot on completion that you can check to reboot soon as everything is installed (A reboot is required you can do it manually or use this function to do it automatically).

NOTE: This can be from a few minutes to several hours depending on different factors.

Confirming Active Directory Domain Services Install

When you reboot you will be asked to login to the domain, and be able to open Active Directory Users and Computers from the Administrative menu. When you do you will see the domain ADExample.com and be able to manage the domain.

Oracle Enterprise Linux Installation

Step By Step Installation of Oracle Enterprise Linux

________________________________________________________________________

1.   insert your Oracle Linux media in your CD/DVD drive and reboot your system (be sure to set your computer to boot from the CD/DVD drive).

2.Hit enter key to start the installation.

On the welcome screen the installation process will prompt you to check and test your installer. You can select OK to test your media, or select skip to continue installing.

On the Graphical Interface, click on the next button.

3.Select your language and click next.

4. Select your keyboard layout and click next.

5. You see the hard disk partitioning section. I’ll select the “remove all partitions on selected drive and create default layout” and “the preview and modify the partition layout” then click next.

6.As you see, the installer created a LVM (Logical Volume Manager) group and created 2 volumes for root and swap. Click next to continue.

7. We do not change the GRUB loader settings, click next.

8. In the network devices screen, set the hostname and static IP address (because we will use this system with Oracle RDBMS) and click next.

9. Select the your region and location on the next screen. You can use the map to select your location.

10. Enter the Root (the administrator account) password, click next.

In the software selection screen, select “customize now” and click next.

11. In software package groups, find “Base system” and mark “System Tools”, then click “optional packages”.

Select the oracle-validated package so our system will have the required users, groups and software packages to install Oracle RDBMS. Thanks Oracle! Click “close” and click next.

12. Click next to begin the installation.

Wait for the system to finish the installation.

13. After finishing the installation, remove the DVD (the installation media) and click reboot.

You see the welcome screen. After 3-4 steps, installation will be done. Click forward.

14. Accept the license agreement (why don’t you install it if you’ll not accept the license agreement?), click forward.

Disable firewall (you can enable it later if you wish), click next.

Disable SELinux (you can enable it later if you wish, but I do not recommend you to enable it while working with Oracle software), click next.

15. f you don’t care about 128 KB memory (on my test system I have only 2 GB), enable kdump. I’ll not use it for this installation. Click forward.

Check if date and time information is correct, click forward.

16. You can create a new user for daily usage, but we don’t need it because oracle-validated package already created the user oracle for us.

17. Click forward until you see the finish button. Click “finish”, your system will be rebooted.

Windows Server Installation

Step By Step Installation 

1. Insert the appropriate Windows Server 2008 installation media into your DVD drive.

2. Reboot the computer.

3. When prompted for an installation language and other regional options, make your selection and press Next.

4. Next, press Install Now to begin the installation process.

5. Product activation is now also identical with that found in Windows Vista. Enter yourProduct ID in the next window, and if you want to automatically activate Windows the moment the installation finishes, click Next.

If you do not have the Product ID available right now, you can leave the box empty, and click Next. You will need to provide the Product ID later, after the server installation is over. Press No.

 Because you did not provide the correct ID, the installation process cannot determine what kind of Windows Server 2008 license you own, and therefore you will be prompted to select your correct version in the next screen, assuming you are telling the truth and will provide the correct ID to prove your selection later on.

7. If you did provide the right Product ID, select the Full version of the right Windows version you're prompted, and click Next.

8. Read and accept the license terms by clicking to select the checkbox and pressing Next.

9. In the "Which type of installation do you want?" window, click the only available option –Custom (Advanced).

10. In the "Where do you want to install Windows?", if you're installing the server on a regular IDE hard disk, click to select the first disk, usually Disk 0, and click Next.

If you're installing on a hard disk that's connected to a SCSI controller, click Load Driver and insert the media provided by the controller's manufacturer.

If you're installing in a Virtual Machine environment, make sure you read the "Installing the Virtual SCSI Controller Driver for Virtual Server 2005 on Windows Server 2008"

If you must, you can also click Drive Options and manually create a partition on the destination hard disk.

11. The installation now begins, and you can go and have lunch. Copying the setup files from the DVD to the hard drive only takes about one minute. However, extracting and uncompressing the files takes a good deal longer. After 20 minutes, the operating system is installed. The exact time it takes to install server core depends upon your hardware specifications. Faster disks will perform much faster installs… Windows Server 2008 takes up approximately 10 GB of hard drive space.

The installation process will reboot your computer, so, if in step #10 you inserted a floppy disk (either real or virtual), make sure you remove it before going to lunch, as you'll find the server hanged without the ability to boot (you can bypass this by configuring the server to boot from a CD/DVD and then from the hard disk in the booting order on the server's BIOS)

12. Then the server reboots you'll be prompted with the new Windows Server 2008 type of login screen. Press CTRL+ALT+DEL to log in.

13. Click on Other User.

14. The default Administrator is blank, so just type Administrator and press Enter.

15. You will be prompted to change the user's password. You have no choice but to press Ok.

16. In the password changing dialog box, leave the default password blank (duh, read step #15…), and enter a new, complex, at-least-7-characters-long new password twice. A password like "topsecret" is not valid (it's not complex), but one like "T0pSecreT!" sure is. Make sure you remember it.

17. Someone thought it would be cool to nag you once more, so now you'll be prompted to accept the fact that the password had been changed. Press Ok.

18. Finally, the desktop appears and that's it, you're logged on and can begin working. You will be greeted by an assistant for the initial server configuration, and after performing some initial configuration tasks, you will be able to start working.