Friday 18 July 2014

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

No comments:

Post a Comment