Creating Service Accounts for SharePoint 2013 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.

Q- Why is their need to create Service Accounts before installing SQL Server 2012 & SharePoint?
Ans- The reason for this is, we will be using these accounts references in their configurations steps.

As of now we have setup our AD on Windows Server 2012 R2, so we will use it for accounts creation.

Before we start 2 things we must know, i.e. 

• We will be creating 2 users, one for SQL Server 2012 setup & other one for SharePoint 2013.
• The user for SQL Server will be having admin rights, while the sharepoint user will be w/o it.

Let's Start the process..............................

Create User Account for SQL Server 2012 Setup :-

1) First log in to your host machine with the user you have created Create User Account

 2) Once your are logged into your system, Go to Server Manager -> Tools. Select Active Directory Users & Computer Option.

3) Active Directory Users & Computers: Using this program we will be adding service accounts aka users in our AD.

  Select Users option in your left pane, on selecting it users existing in your AD will be displayed.

4) Create User with Admin Rights: This user will be required for SQL Server 2012 Configuration.
Right click the "Administrator" User already created, and click copy.

 Once you have clicked copy, it will open an add user window. 

6) Create User - Now provide user log in name, i used "sqlAdminAcc" name for admin user that will be used in SQL Server Config.

    Press Next -> Now provide password for the user & remember select "Password Never Expires" radio button.

    Press Next -> It will ask you to confirm the details. If all is well, press finish.

7) Your User is created.............

    Right Click the newly created user i.e. "sqlAdminAcc" and click "Properties".

   Hey, did you noticed that this user is member of "Administrator Group" ....... So we are done.....!!!!

Create User Account for SharePoint SetUp:

1) You are already logged into the host machine and Active Directory User & Computers program is running.

2) Create a New User:

    Click Users on the left Pane. Right click Users -> Select New -> Choose User option

3) Enter User Details:-

     Provide login name -> "spFarm". This is the user i will be using for SharePoint Setup Configuration.

    Press Next -> Provide Password Details

    Note: Remember to select "Password Never Expires" radio button and untick "User must change password at next logon".

    Press Next -> You will be asked to confirm the created user details. If all is well, press finish.


4) Congrats you have successfully created the user..............

Now we will proceed to Install & Configure SQL Server 2012 on Windows Server 2012 R2

Enjoy :-)

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