14 Feb 2013

Least Privileged for SharePoint


1. SQL Server Service Account (sp_sql): run mssql server, mssql agent svc
- Standard Domain User Account

2. SharePoint Setup User (sp_admin): run as logon account when install SP or configure SP
- Standard Domain User Account
- Local admin group of every sp server of the farm
- SQL role: db server security, db creator, db admin

3. Server Farm/DB Access Account (sp_farm) 
- Standard Domain User Account

Create account for every services
-App Pool Account
-App Pool Account for BDC service app, excel app, ..






21 Jan 2013

web part export

Export list from working site
Import list to site. Create custom view and make it as default.
Add web part and select imported list. Select custom view as in step 2.


Total Pageviews