SharePoint Service Accounts:
| User Account | Local Admin | Domain Account | Purpose |
| sqlsetupadmin | Yes | Yes | We have to Install SQL Server with this account and this account will be the owner of SQL Instance. |
| sqlserviceacc | No | Yes | This is a service account and when the SQL Server Installation configures MSSQLSERVER and SQLSERVERAGENT services to run under this account. |
| spsetupadmin | Yes | Yes | This account which use to Install the SharePoint. This account needs to have privileges to Security Admin and DB creator in the SQL Server. This is the only account we need to give the SQL Server permissions manually. This account is used by Human been who access the SharePoint for Administrative purposes such as add servers to farm, Remove servers etc. |
| spfarmadmin | No | Yes | This is the service account which is use to configure services in the farm such as timer jobs, internal services etc. |
Now we have to install the SQL server in back-end sever .for that login with SQL Admin (sqlsetupadmin) account. Run the SQL software setup file and click on the “New SQL Server stand-alone installation or add features to an existing insulation” option as below.
After that we will see below screen. As per below screenshot we have to turn off the Windows Firewall and click on the Re-run button to remove the windows Firewall warning and for successful installation.
Windows Firewall warning has been removed. Click on Next button in below screen.
Select the “SQL Server Feature Installation” option to choose the required features.
Choose the feature you want to install. Do not select all features if you will not use them, as this will use server resources that could be used by the SQL Server database engine or Windows. I have selected the SQL Server Database Engine along with a few shared features as shown in the below screenshot. Once you select the required feature then click on “Next”.
From below screen select “Default instance” and click Next.
Install the all the features using “sqlserviceacc” account as below.
Under “Server Configuration” select Windows authentication mode option if you want you can choose Mixed Mode authentication as per your requirement. Click on “Add Current user” to add sqlsetupadmin as a SQL administrator.
Select Install and configure option from below screen and click next.
From below screen click on “Add Current User” to give the sqlsetupadmin permission Distributed Replay controller and click on next.
SQL installation has been successfully completed.
After installation of SQL Server we need to give the sys admin permissions to spsetupadmin to install the SharePoint.
Add the permission from SQL Server management studio as below.
Now login as a spsetupadmin to install the SharePoint.
Run the SharePoint setup file and install the prerequisites from below screens.
Enter the Product key and click on continue.
After installation we have to configure the SharePoint product configuration for that please click on next.
Select “Yes” and click on “Next”.
Now we are creating fresh SharePoint installation so select “Create a new server farm” option as below and click Next.
Mention the data base server name, data base name (for the configuration data base) and specify the form account user name and password after that click “Next”.
In below screen we have to mention “Passphrase” password and click “Next”. Always please remember this password, because if want to rerun the product configuration we have to use this.
From below screen mention the port number for the central admin site and select NTLM authentication. Click “Next”.
Click on Finish.
SharePoint installation has been successfully completed.
No comments:
Post a Comment