Monday, December 24, 2012

Installation of Microsoft SQL Server 2012 Step by Step

You are reading :  SharePoint Server 2013 installation Part 2

2) Create  a user in Active directory and name it svcSQL. (Add User to Active Directory Blog post).

3) Add user SPAdmin to local administrator group which was created in last blog post.

   To Add user to Administrators group : Go to : Server Manager >> Tools >> Active Directory Users and Computers

   Then Click on Builtin OU and look for Administrators group, double click on that and jump on Members tab and Add SPAdmin

   user to it’s members. that’s it.

   Insert SQL Server 2012 media and start installation.

4) Click on Installation link.

Installation Tab
5) Click on New SQL Server stand alone installation.

6) Click Ok.

7) Enter product key or select free edition and click Next.

8)  Accept the License terms.

9) If you want to you can install updates or skip by uncheck select box and click Next.

10) Again click Next.

11) Select SQL Server Feature Installation and click Next.

12) Select Database engine, SQL Server Replication, Full -Text and Semantic  Extractions for Search,

      Data Quality Service, Analysis Services, Reporting Services – Native, Reporting Services – SharePoint,
      Management Tools – Basic and Complete both. and click Next.

13) If it gives 0 warnings, Click Next.

14) Keep default instance and click Next.

      again click Next.

15) Now I’ve created three service account in Active directory named
    • SQL Server Database Engine : svcSQL
    • SQL Server Agent : svcSQLAgent
    • SQL Server Analysis Service : svcSQLAnalysis


      Click Next.

16) Select Mixed Mode SQL Server authentication and put password for sa account.

      Click Add Current User button to add current user as SQL Server admin


       Click Next.

17) Enter svcSQLAnalysis service account as admin for Analysis service access. and go Next.


18) Select Install Only option for Reporting service and go Next.


19)  go Next.

20) go Next.

21) Click install button to finish.


and the installation of SQL server is done.

Also read :

If any query please post comments



  1. I dunno if I missed it but I didn't see where I should add the SQL server to the domain. I thought it was always best practice to separate the SQL server and AD and SP servers to different machines.

  2. Nice guide, but the installation warns you about installing it on DC :-)

  3. in step 15 i havent got any chance for giving input password. Even the first two folders are also from NTservices\sql...... but i complete installation by the same. now while loging into the server i am getting error. can any one help on this......

  4. Hi Anurag,

    Getting following error while installation of SSMS
    Could not write value to key \SOFTWARE. Verify that you have sufficient access to that key, or contact your support personnel.
    Please help me to resolve this issue.

  5. Hi Srinivas,

    Hope the account that your are using the is added in local admin group and If yes then also check whether you started the installtion by right click run as administartor.

    Error shows that account does not have required permssion to update the regsitry of the server.


  6. Hi Anurag,

    I'm new to SharePoint, just started to learn, I have followed your install guide, and I have managed to install SharePoint 2013, 2 things i'm not sure about :-
    a) when you log into the system, are you loging in as DOMAIN\administrator, or can we login as SPAdmin, (Spadmin is a member of the administrator group)
    b) with which account/s can I login when launching SQL management studio I have created the accounts as per your SQL server installations instructions.

    Kind regards,

  7. This list will be helpful to everyone who will use it, including me. Keep doing what you are doing ! Thanks for sharing with us your web-site.

  8. This is a good tut, thx, but I suspect there are things that must be done AFTER this SQL server install and BEFORE the install of Sharepoint 2013 - I just wish I knew what they were :)

  9. I had this issue few day ago and couldn't fix it. Thats when I started googling and found a team of friendly people called called ServerBuddies.
    They provide quality remote server management, including troubleshooting, Server Management, Plesk Support, Server Maintenance, Server Monitoring, Server Troubleshooting and support at a affordable rates. Here are option for Server Management, Server Maintenance, Server Monitoring, Server Troubleshooting, Server Optimization, Plesk Support, Linux Support, cPanel Support and Plesk Support.
    They are great, I highly recommend to use these guys!

  10. I think that thanks for the valuabe information and insights you have so provided here.
    server installation dubai

  11. Usually I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Great work admin.Keep update more blog.
    SQL Server Training in Chennai

  12. Thank you for this post!! I have just discovered your blog recently and I really like it! I will definitely try some of your insights.
    SQL Training in Chennai | SQL DPA Training in Chennai | SQL Training institute in Chennai

  13. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
    Data Science Training in Chennai | Data Science Course in Chennai
    Python Course in Chennai | Python Training Course Institutes in Chennai
    RPA Training in Chennai | RPA Training in Chennai
    Digital Marketing Course in Chennai | Best Digital Marketing Training in Chennai

  14. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live.
    digital marketing course in chennai | digital marketing training in chennai | social media marketing chennai | best digital marketing course in chennai