Prerequisites :
(i) Install domain server
(ii) Install dotnet framework 3.5
(iii) Install sqlserver 2012 tabular mode
(iv) Install iis
(v) Install sharpoint server 2013
Setup and configure a domain controller on windows server 2008 r2
1) Login to your windows server and start the server manager.
2) Navigate to the Server Roles tab and press on the “Add Roles” button.
3) The Add Roles Wizard is going to open up, click Next.
4. The Wizard will display a list of Roles. Choose the Active Directory Domain Services Role.
5. The Active Directory Domain Services Role requires adding features to the server. Click on“Add required features” on the appearing screen and then click on next.
6. On the following screen click on Install and wait for the installation to finish. When the installation finishes click on Close.
7. At this point the Active Directory Domain Services are not configured yet.
8. If we click on Active Directory Domain Services button we get to the following screen. Our next step will be configuring Active Directory Domain Services using dcpromo.exe.
9. We are about to start the Active Directory Domain Services installation Wizard.
10. Navigate to the following screen. Choose the “Create a new domain in a new forest option”and click on next button.
11. Type in your Domain name.
Example : VERADIS0.COM
12. Choose the oldest operating system in your network. This option exists for backwards compatibility of different features.
13. If your Domain Controller is a stand-alone server you don’t have to choose the DNS server option. If otherwise, it’s recommended to leave it checked.
14. Specify the folders that will contain the Active Directory controller database, log files. And SYSVOL and click on Next.
15. Choose a password for Restore mode Administrator account. (This is not the Domain Administrator account, this is an additional account used for recovery)
16. When the wizard finishes configuring the settings reboot your server.
17. After rebooting when you first log on the server is not going to accept your machine Administrator account.
18. In order to solve this issue you need to choose the “Switch User” button and login with your Domain Administrator account which is basically the same user account and password but now it belongs to a domain the domain name is needed. For example: VERADIS0\Administrator.
(ii) Install dotnet framework 3.5
1. In the Server Manager interface, select Add Features to displays a list of possible features.
2. In the Select Features interface, expand .NET Framework 3.5.1 Features.
3. Once you expand .NET Framework 3.5.1 Features, you will see two check boxes. One for .NET Framework 3.5.1 and other for WCF Activation. Check the box next to .NET Framework 3.5.1 and click Next.
Note: If you do not expand .NET Framework 3.5.1 Features and check it, you will get a pop-up titled Add Features Wizard as shown below.
4. Click Cancel and expand .NET Framework 3.5.1 Features and then check .NET Framework 3.5.1 check box below it.
5. you cannot install .NET Framework 3.5.1 Features unless the required role services and features are also installed.
6. In the Confirm Installation Selections interface, review the selections and then click Install.
7. Allow the installation process to complete and then click Close.
(iii) Setup and configure sqlserver 2012 with Tabular Mode. Download and install sql server 2012 service pack 1
Analysis Services Configuration
If you have selected Analysis Services component you will be presented
with the following screen.
Select the Tabular Mode
Click Add Current User
Click Next
Complete install the sql server 2012 and then install service pack 1 install
SQL Server Setup to install PowerPivot for SharePoint.
In this step, you run SQL Server Setup to install PowerPivot for SharePoint. In a subsequent step, you will configure the server as a post-installation task.
Insert the installation media or open a folder that contains the setup files for SQL Server.
Click Installation on the navigation pane to the left.
Click New SQL Server stand-alone installation or add features to an existing installation.
On the Setup Support Rules page, review any warnings and click OK.
On the Product Key page, specify the evaluation edition or enter a product key for a licensed copy of the enterprise edition.
Click Next.
Accept the Microsoft Software License Terms of agreement, and then click Next.
Update the setup files if you are prompted to do so.
On the Setup Support Rules page, setup identifies any problems that might prevent it from installing. Review the list to determine whether Setup detected potential problems on the system.
9. Click Next. Wait while SQL Server Setup program files are installed on the server.
10. In Setup Role, select SQL Server PowerPivot for SharePoint.
11. Optionally, you can add an instance of the Database Engine to your installation. You might do this if you are setting up a new farm and need a database server to run the farm’s configuration and content databases. If you add the Database Engine, it will be installed as a PowerPivot named instance. Whenever you need to specify a connection to this instance (for example, in the farm configuration wizard if you are using that wizard to configure the farm), enter the database name in this format: <servername>\PowerPivot.
13. Click Next.
14. On the Feature Selection page, a read-only list of the features that will be installed is displayed for informational purposes. You cannot add or remove items that are preselected for this role. Click Next.
15. On the Installation Rules page, click Next.
16. On the Instance Configuration page, a read-only instance name of 'PowerPivot' is displayed for informational purposes. This instance name is required and cannot be modified. However, you can enter a unique Instance ID to specify a descriptive directory name and registry keys. Click Next.
17. On the Disk Space Requirements page, verify you have sufficient disk capacity to install the feature and then click Next.
18. On the Server Configuration page, type desired account information.
For SQL Server Analysis Services, you must specify a domain user account. Do not specify a built-in account. Domain accounts are required for managing the Analysis Services service account as a managed account in SharePoint Central administration.
19. If you added the SQL Server Database Engine and SQL Server Agent, you can configure the services to run under domain user accounts or under the default virtual account.
Never use your own domain user account to provision any service. Doing so grants the server the same permissions that you have to the resources in your network. If the server is compromised by a malicious user, that user will be logged in under your domain credentials, with the ability to download or use the same data and applications that you do.
20. Click Next.
If you are installing the Database Engine, the Database Engine Configuration page appears. In Database Engine Configuration, click Add Current User to grant your user account administrator permissions on the Database Engine instance. Click Next.
On the Analysis Services Configuration page, click Add Current User to grant your user account administrative permissions. You will need administrative permission to configure the server after Setup is finished.
On the same page, add the Windows user account of any person who also requires administrative permissions. For example, any user who wants to connect to the Analysis Services service instance in SQL Server Management Studio to troubleshoot database connection problems or get version information must have system administrator permissions on the server. Add the user account of any person who might need to troubleshoot or administer the server now.
Click Next.
Click Next on each of the remaining pages until you get to the Ready to Install page.
Click Install.
(iv) To Install IIS 7.5 on Windows Server® 2008 R2
You can perform this procedure using the user interface (UI) or a script.
Using the UI
Click Start, point to Administrative Tools and then click Server Manager.
In Roles Summary, click Add Roles.
Use the Add Roles Wizard to add the Web server role.
(v) Install sharpoint server 2013
Once you have finished the installation of Service Pack 1, reboot your machine. Now open SharePoint Server 2013 setup folder and click on the Splash file in your setup, which will look similar to the following –
Once the Splash screen opens, you will find an "Install Software prerequisites" link. Clicking on that link brings up a list of all software to be installed as prerequisites –
Click on "Next" button and accept the agreement. This will start installing the prerequisites. You will get the following confirmation screen once you finish installing all the prerequisites –
Now restart your server. After this, go to the Installation folder of SharePoint Server 2013 and rerun the Splash screen. Click on "Install SharePoint Server" as shown below –
The installer now asks you enter the Product key. Enter the product key and click on continue as shown below –
Now accept the agreement and go to the next step. Here the setup asks you if you want to do a -
1. Complete Installation.
2. Stand-alone Installation.
I have chosen a "Complete" installation. Now click on "Install" button which will start the installation.
Once the installation is complete, you will now need to run the SharePoint Products Configuration Wizard. Make sure you have the check box "Run the SharePoint Products Configuration Wizard now" checked and click on the "Close" button as shown below –
Click on the "Next" button and a warning dialog box appears as shown below –
As soon as you click on "Close" button, SharePoint Product configuration wizard will show the welcome page as shown below –
The Wizard will ask for the database server name and it will provide the default configuration database name. It will also ask you to specify the database access account. Provide the appropriate information by keeping the database name default "SharePoint_Config" as shown below –
Let's start the "SharePoint 2013 Products Configuration Wizard" and run the same with the following specifications -
Now provide the configuration settings for "SharePoint Central Administration Web Application" as shown below - [I am using the default settings]
The next step shows details of our configuration which we did so far -
Now click on "Next" button to apply the configuration setting. Once the configuration is completed, your will get a message as shown below –
Click on "Finish" button and it will start the SharePoint Central Administration website as shown below –
