Install & Configure SQL Server 2012 on Windows Server 2012 R2

This post is a part of the series Integrating SharePoint 2013 with OAM 11g R2PS2 so i hope you have followed the steps mentioned their.

Even though you haven't this post will help you with the default setup as well. Need not to worry ;-)

Assumptions: You have had downloaded the SQL Server 2012 setup beforehand.

So let's start with the setup...............

1) Start the SQL Sever installer:-

    Here select the first option in the right column, as this is fresh installation.

2) Setup Support Rules:

  Note: If you see any error on this window, kindly take a look at the logs.

3) Product Key:- Kindly provide the product key.

4) License Terms:- "I accept the terms"......and proceed Next

5) Setup Role:- Select the first option and proceed Next....

6) Feature Selection: Make you select Database Engine & Management Tools features.

7) Installation Rules:- Make sure you see green signal here, and proceed Next...

8) Instance Configuration: Important Step of installation............

    Here i have selected the default server instance name i.e. "MSSQLSERVER", remember this name.

9) Disk Space Requirement:- Proceed Next if you have disk space left ;-)

10) Server Configuration: Remember we have created service accounts in our AD. Use the admin account created i.e. "sqlAdminAcc".

    For SQL Server Agent & Database Engine we have used the admin account.

Note: In case you are not setting up the SQL Server for SharePoint purpose, than you can use the default user account as well.

11) Database Engine Configuration:-

  Choose Windows Authentication Mode.

12) Error Reporting:- Proceed Next.........

13) Installation Configuration Rules: Proceed Next..........

 

 14) Ready To Install:-

15) Complete:- Bravo...!!!! You are done............. Congrats :-)

 

Congrats your installation is complete...... But now you need to start the SQL Service & need to be ready for some issues as well in starting them (if you are lucky..... hehehe)

Note: Once your sql server is installed, do  look for Troubleshooting link. It will reduce your upcoming effort.

Need not to worry..... kindly look into the post "Starting SQL Server 2012 "

Enjoy :-)

Integrating SharePoint 2013 with OAM 11g R2PS2 (Windows Server 2012 R2)

Before we start please read the note...

Note:

• We will be installing & configuring the complete setup on a host machine i.e. a virtual machine. Usually in corporate setup's we are provided with the host machines to test our setup.
• We will be doing this integration on Windows Server 2012 R2

Start following the link's mentioned below:

1. Create User Account
2. Install & Configure Active Directory
3. Create Service Account for SQL Server & SharePoint Setup
4. Install & Configure SQL SERVER 2012 on Windows Server 2012 R2
5. Install & Configure SharePoint 2013
6. Integrate OAM with SharePoint 2013
7. Troubleshooting

 To be continue.....................


Enjoy :-)

Install & Configure Active Directory in Windows Server 2012

Let's start setting up AD (Active Directory):

We will be setting up AD on a host machine, so before we start remember we discussed about creating user account, in the series of setting up SharePoint 2013.
http://hands-on-oam.blogspot.com/2014/07/creating-user-accounts-in-windows.html

Follow the steps:-

1) Before starting the AD Setup, add a user under ->

“Allow user to access host option” -> Click this option you will prompted with uid entry, enter domain name that you will be creating followed by user name.

Eg: bored\clk

2) Go-to Managed Server-> Select "Add Roles & Features" option

3) Add Roles & Features Wizard will be opened, press Next.

4) Installation Type:  Select Role-based or feature based installation, press Next.

5) Server Selection: 

 In this you will be presented with the list of server, in my case there is only one. Choose the appropriate one.

6) Select Server Role:

In this First select "Active Directory Domain Service", the moment you select the option, it will open a pop-up, where it will ask you to add features. Click the "Add Features" button.

7) Once you have added the features, now click "Next".

8) Now it's time to select features, we will be using the basic one's only.

                Click Next.........

9) AD DS:

Select Next.....................

10) Confirmation Step:

     Click Install.........

11) Installation Begins...............

12) Once the installation is done, it will ask to promote the server to domain controller.
Choose that option.......


Now we will be promoting the Windows Server 2012 to DC (domain controller)
Promote Windows Server 2012 R2 to Domain Controller



Enjoy :-)