I have 3 servers
- WFE server
- Application Server
- Database Server
I am using Windows 2008 R2 and SQL server 2008
Assuming SQL Server 2008 is installed with a Server account E.g.
SQL_service, can someone suggest if the following are the best practices
Plan for the Ports to be opened between
App to Database server
WFE to Database server
APP and WFE
Plan the Service applications in my case
Managed Metadata Service application
Business Service application
Search Service application
Service accounts for SharePoint
Spfarm- for the farm configuration and
sp_admin- for the administration purposes
spmmc- managed metadata
spbcs- for business connectivity services
spuser- for user profile with replicate directory changes permission
Install pre requisite's for SharePoint
Install SharePoint Binaries
Should we login on the APP server as the
spadmin account or
spfarm account to install the pre requisites, SharePoint binaries and configuration of the service applications?
Is it a good practice to create service accounts for all the service applications
as we would end up creating separate applications pools for each of them instead of having one service account? E.g.
spservices for all the service applications - This would only create one application pool for all the service applications except for user profiles.