MOSS 2007 – Step by Step – Table of Content

In this post, we’ll create a couple of accounts that are required for SharePoint in order to make it talk to the SQL Server and other Administrative actions. Refer to this article if you want to learn more about different accounts.

Two domain accounts that we are going to create and configure are…

Moss Administrator’s account name : dotnetscraps\MossAdmin
SQL Server service account : dotnetscraps\SQLAdmin

    Switch to the machine DC.
    Click Start –> Run –> Type dsa.msc and hit Enter.
    Switch to Users

    Right Click Users –> Select New –> User

    Type in the following and click Next.

    Make the following changes (I am using Password as pass@word1) and click Next, Finish.

    Once again, Right Click Users –> Select New –> User
    Type in the following and click Next.

    Make the following changes (I am using Password as pass@word1) and click Next, Finish.

    The accounts are created, let’s give it appropriate permission in SQL Server.
    Switch to AS machine, and open SQL Server Management Studio
    Connect to the Database server by click Connect.

    In the left pane, expand Security –> Right click Logins –> Select New Login…

    Click the Search button

    Type dotnetscraps\sqladmin and click Check Names button

    Click OK.

    Ensure Windows Authentication is checked. Switch to Server Roles in the left pane.

    Select dbcreator and securityadmin. Click OK.

     Now, let’s take care of MossAdmin account.
     You need to do this in all the machines AS, WFE1 and WFE2.
     Right Click on My Computer and select Manage.
     Expand Groups. Double click Administrators. Then click on Add… button.

     Type mossadmin and click Check Names button. Click Ok.

     PLEASE DO IT ON ALL THE MACHINES if you want to avoid unpleasant surprises later on
     We are all set now. Very soon we’ll have a fully functional web farm which has Network Load balancing enabled and all the accounts setup.  All the hard work that we have done so far will pay off in the next post when you see SharePoint farm up and running.

Next step would be to create a SharePoint farm and launch Central Administration Tool.

We will discuss about it in the next post. Stay tuned…

-Rahul

Quote of the day:
If at first you don't succeed, find out if the loser gets anything. - Bill Lyon