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.

 
NewInstallationOption
6) Click Ok.

SetupSupportFile
 
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.

ProductUpdate
10) Again click Next.

SetupSuportRule
11) Select SQL Server Feature Installation and click Next.

SQLServerFeatureInstallation
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.

InstanceFeature 
13) If it gives 0 warnings, Click Next.

InstallationRule
14) Keep default instance and click Next.

InstanceCreate
      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

ServiceAccounts

      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


ServerConfig

       Click Next.

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


AnalysisService

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


ReportingService

19)  go Next.

20) go Next.

21) Click install button to finish.


Install_Final

and the installation of SQL server is done.

Also read :

Thanks,
If any query please post comments


 

12 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.

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

    ReplyDelete
  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......

    ReplyDelete
  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.

    ReplyDelete
  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.

    Regards
    Praveen

    ReplyDelete
  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,
    Nanji

    ReplyDelete
  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.

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

    ReplyDelete
  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!

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

    ReplyDelete
  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

    ReplyDelete