Kindly follow the below mentioned steps to Install SQL Server 2012 R2
1. Browse the directory of your system where you have Microsoft SQL Server 2012 Setup files.
2. Right click on Setup.exe files and run as Run as administrator
2. Following Splash screen will keep you waiting until SQL Server installation Center screen appears.
3. You will get SQL Server installation Center screen with multiple options as depicted below in screenshot
4. Click on Installation (2nd Option) from the left hand penal of the screen. Now, you should be able to see the multiple option for installation.
5. Click on New SQL Server stand-alone installation or add features to an existing installation link , you will get a splash screen that will keep you waiting until the Microsoft SQL Server 2012 Service Pack 1 setup process will be completed.
6. On the Setup support Rules screen, Installer checks for the potential issue that might occur at the time of installation.
7. In the following Product Key screen, you have to provide a valid license product Key. If you are installing free version, you need to select the Specify a free edition radio box on the screen. else, you can provide the license keyfor it. click on Next button to continue
8. On the license Terms screen, read the license terms carefully and check the accept the license terms option if everything seems good in license terms.
9. On the Product Updates screen, it Checks for the hot fixes and updates for SQL Server 2012. Click on Next button to continue
10. On the Install Setup Files screen, Setup files will be downloaded. You can click on the install button to continue
11. Again, the Setup Support Rules screen appears,it identifies the installation issues if any. Click on Next button to continue
12. On Setup Role screen, select the SQL Server Feature Installation radio button and Click on Next Button to continue
13. On the following screen, you should be able to select the Features of SQL Server that you want to have in your Installation. Below are the main Feature that you should select in this installation. you can also select based on your requirements - Instances Features
- Database Engine Services
- Full-Text and Semantic Extractions for Search
- Analysis Services 2.Shared Features
- Shared Features
- Reporting Services - SharePoint
- Reporting Services Add-in for SharePoint Products
- SQL Server Data Tools
- Management Tools – Basic
- Management Tools – Complete
14. On Installation Rules screen, this screen will show you if Installation process get stuck somewhere. Click on Nextbutton to continue
15. On the Instance Configuration screen, you can choose the default SQL Server Instance or create a new Named Instance. Also, you should be able to change the Instance directory on Windows Server 2012 R2. Click on Next button to continue
16. On the Disk Space Requirements screen, you will be able to see the details about required disk space for installation. If your Windows Server 2012 R2 has enough space to install then you can click on Next button to continut
17. On the Service Configuration screen, Go to the Service Accounts tab and perform the below mentioned actions
- Change the Startup Type for the SQL Server Agent to Automatic.
- Change the Account Name for the SQL Server Database Engine to NT AUTHORITY\SYSTEM.
- Change the Account Name for the SQL Server Analysis Services to NT AUTHORITY\SYSTEM.
- Click Next to move to the next page.
18. In the following screen, Go to the Server configuration tab and select the Mixed Mode (SQL Server authentication and Windows authentication) option. Also, Add the current logged in user as System Administrator Account for this SQL Server Instance. Click on Next button to continue
19. On the Analysis Services Configuration screen, Select the current logged in user as a System Administrator for Analysis Services. Click on Next button to continue
20. On the Reporting Services Configuration screen, Select the Install Only radio button and click on Next Button to continue
21. On the Installation Configuration Rules screen, you should be able to see the issues that might be occur during installation.
22. On the Ready to Install screen, you should be able to all the Features details that you wanted to install. If everything looks OK for you. Click on Next button to continue
23. On the Installation progress screen, you should be able to see the downloading status of the required Softwares and the stustas of installation. Click on Next button
24. On the Complete screen, you will get the status of all the features that you have selected to Install. Now, you can close the screen and restart your Windows Server 2012 R2.
25. After restart your Windows Server 2012 R2, you should be able to login in created SQL Server Instance
Once, you have done with installation. you need to configure Named Pipes protocol for your SQL Server 2012.
To Configure the Named Pipes protocal, browse the given path using SQL Server Configuration Manager
SQL Server Configuration Manager >> SQL Server Network Configuration >> Protocols for MSSQLSERVER.
and locate the Named Piped protocol in right panel of the screen and Enabled it.
Now, you are good to use SQL Server 2012 R2 for your SharePoint 2013 setup. Enjoy ... :)
That's all..
No comments:
Post a Comment