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 :-)

PROMOTING WINDOWS SERVER 2012 TO DOMAIN CONTROLLER

Let's start promoting server to DC:

At this time you should be done with the AD setup, that we learnt from Setting up Active Directory in Windows Server 2012

Now time to promote the server to DC. Follow the steps:

1) The moment you select the option to promote the server to DC, appeared after the AD setup completion.
You will be prompted with Deployment Configuration.

2) Select the deployment operation: Choose Add a new forest

   Now you need to provide the Root domain name. Like the one i provided "bored.local"
   Once done click "Next"....................

3) Domain Controller Option: You need to provide the DSRM Password.......

  After configuring the password, click "Next".....

4) DNS Delegation Warning:

Just press "Next" and move forward........

5) NetBIOS Domain Name Check:
   

   Here it will be checked the netbios name given (by default it is the domain name     provided by you while doing deployment configuration). If there seems to be some   conflict than you need to change the name.

Note: If some conflict arises here than you need to change the name here as well as in the Deployment Configuration step.............

Once done click "Next"..........

6) Paths:

   In case you feel path needs to be changed, provide your desired one and just move ahead by clicking "Next"...................

7) Review Options: You will be presented with the Installation Summary..... If all seems ok to you proceed Next...

8) Prerequisites Check: It will confirm all is well......

9) Installation: Now proceed with the Install..........

10) Once the installation is done System will be restarted....

11) Now here comes the important step, as we discussed earlier in previous posts that when we will be installing the AD-DS on a host machine i.e. a virtual machine in a corporate network. The user no longer will be able to log in to the system with his/her company credentials .... 
So as now we are done with our own AD setup. It is time to log in to the system with our own created credentials.

Like i created a user before AD setup with the bored\clk credential correct as that is required so that now we can log in to the system....

Time to log in to the system............!!!!!!!!!!!!!!!!!!!! 
username = bored\clk
password = Abcd@123!

Similarly you provide your own credentials & you should be able to log-in to the system.............

Cool, so we are done with the AD setup..... Now proceed to Create Service Accounts that will be used for setting up SQL Server 2012 & SharePoint 2013
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 :-)

Creating User Accounts in Windows Server 2012 R2

Create User Account:

This post is a part of the series Integrating SharePoint 2013 with OAM 11G R2PS2 (Windows Server 2012 R2)

Why this is important to create user account before-hand moving to install the Active Directory?
Answer:->

• With this user account we can log in to the system. This user account will become part of the AD on successful setup. Thus we have an account to log into the system in both success & failure case.

Let's Start setting up the User Account:-

1) Start Menu -> Control Panel -> User Accounts. Select User Accounts Option

 2) Select Manage User Accounts.

3) User Accounts Menu will be opened. Under this Select Advance Tab.

Under Advance Tab, select Advanced Option.

3) Local User and Groups Manager will be opened.

Select "Users Option" visible in the tree.

 4) Now in the middle column where the users are listed, do right click and select New User option. This will open a form which needs to be filled with the user details.

Remember don't select "User must change password option", untick the selection and than select "Password never expires" Option. Now press Create Button.

Your user gets created.... :-)

5) Giving Admin rights to the user: The user created above is not having the admin rights.
To provide admin rights to the user, do as following:

a) Open User Accounts Options (Start Menu -> Control Panel-> User Accounts -> Manage User Accounts)

b) You will find your created user entry here, now double click the user. It will open user properties.

c) Now select Group Membership tab.

By Default the user is created with standard rights. Now we need to change the same to admin.

d) Select the Administrator Option. And press OK Button.

e) Now you will see that the user properties is changed from standard to administrator.

f) Add the created user to the host:-
On your Windows Server Desktop you will see “Allow user to access host option” -> Click this & you will prompted with uid entry.

Enter:  <machine_name>\<created_user_name>
Eg: slc01att\bunty

Without adding user to the system, you won't be allowed to take remote of the machine.

Test:- To Log-in into the system with the created user credentials 

Log-off from the system and log-in again but this time with new user credentials just created above.You should be able to log-in
Syntax -> hostname\username followed by password
Eg: slc01att\bunty -> Password "abcd123!"


Now we proceed to Install & Configure Active Directory on Windows Server 2012 R2.

Enjoy :-)