Creating service account and administrative account for installation of SQL Server, SharePoint.
Introduction
Creating service account and administrative account for installation of SQL Server, SharePoint.
Following task has to be done on COCSITDC Server – Login as Administrator
In this task we are going to create service and administrative account for SQL Server and SharePoint installation.
Here we need four accounts :
- SP_Admin – A user account used to install SQL Server, and SharePoint 2013, Project Server
- SQL_Servcie – A Service account used to run different SQL Server services.
- SP_Farm – A Service Account used by SharePoint to configure and Manage SharePoint Server Farm.
- SP_ServiceApps – A Service Account used to run various service applications of SharePoint.
- Open start menu of Windows Server 2012, from start open Active Directory Users and Computers.On “Active Directory Users and Computers” page, in left pane right click on COCSIT.COM Node, Move to New and then click on Organizational Unit.

- On Organizational Unit page, write SharePoint as Organizational Unit.In this Organizational Unit, we will store all service and administrative account related to SQL Server and SharePoint.

- Right click On SharePoint Organizational Unit, move to new and then click on UserOn New Object-User Page
• For Full Name type - SharePoint Administrator
• For User logon name type SP_Admin and click on Next

• For Password – Type appropriate Password for this user and Uncheck all options
i. User must change password at next logon
ii. User cannot change password
iii. Password never expires
iv. Account is disabled
• Click on next and then Finish

- Right click On SharePoint Organizational Unit, move to new and then click on UserOn New Object-User Page
• For Full Name type – SQL Service
• For User logon name type SQL_Service and click on Next
• For Password – Type appropriate Password for this user and Uncheck all options
i. User must change password at next logon
ii. User cannot change password
iii. Password never expires
iv. Account is disabled
• Click on next and then Finish
- Right click On SharePoint Organizational Unit, move to new and then click on UserOn New Object-User Page
• For Full Name type – SharePoint Service Apps
• For User logon name type SP_ServiceApps and click on Next
• For Password – Type appropriate Password for this user and Uncheck all options
i. User must change password at next logon
ii. User cannot change password
iii. Password never expires
iv. Account is disabled
• Click on next and then Finish
- 6.Right click On SharePoint Organizational Unit, move to new and then click on UserOn New Object-User Page,
• For Full Name type – SharePoint Farm Admin
• For User logon name type SP_Farm and click on Next
• For Password – Type appropriate Password for this user,Uncheck all options
i. User must change password at next logon
ii. User cannot change password
iii. Password never expires
iv. Account is disabled
• Click on next and then Finish
Conclusion
In this article, we have Created Four accounts in SharePoint Organizational Unit. So far we have finished almost all activity on COCSITDC. In next article we will see COCSITSP Server for installation of SQL Server 2012, SharePoint 2013, and Project Server 2013.