Hey Folks,
I do this so often I thought I’d write myself a quick step-by-step rapid install for PS2010. My next install related post will be reporting on a powershell script based install. Enjoy!
- Install Windows Server 2008 R2
- Connect to domain
- Install proper server roles
- Application Server
- Web Server
- Install SQL 2008 R2, etc., server
- Configure network settings
- SQL Server Configuration Manager –> SQL Server Network Configuration
- TCP/IP Enabled
- SQL Server Configuration Manager –> SQL Server Network Configuration
- Enable CLR
- sp_configure ‘clr enabled’, 1
- go
- reconfigure
- go
- Configure Analysis Services
- Add Farm Administrator to OLAP Users Group
- Configure Farm Administrator account to have administrative permissions in SQL Analysis Services
- Configure network settings
- Install SharePoint Server 2010
- Install Prerequisites
- Install SharePoint Server 2010
- Install Project Server 2010
- Run SharePoint Configuration Wizard
- Run Farm Wizard
- Use Farm Admin unless granular
- Start required services
- Create Top-level site
- Grant Permissions
- Site Actions –> Site Permissions
- Grant Permissions
- NT AUTHORITYNETWORK SERVICE
- Visitors (Read)
- Create a Project Server Web App
- Central Administration –> Application Management –> Manage Service Applications
- Click the Project Server Service Application
- Click Create New Project Web App Site
- Enter parameters and click OK
- Configure Excel Services
- in SQL Management studio, add report viewers security group to reporting database with db_datareader and public permissions
- URLs for Trusted Data Connections and Report Libraries
- From the Business Intelligence center, click on Data Connections the the English (United States) check box.
- click View Properties
- Right click English (United States) and select copy shorcut.
- Business Intelligence, click on Data Connections
- Navigate to Central Administration –> Manage Service Applications
- Click on the non-hyperlink portion of the row for Excel Services Application
- Click the Manage button in the ribbon
- Click the Global Settings link
- Scroll to the External Data area and enter ProjectServerApplication in the Application ID box.
- Click OK
- Click the Trusted File Locations link
- Click Add Trusted File Location
- paste your address previously copies in teh Address box
- Check the Children Trusted checkbox
- Deselect the checkbox for Warn on Refresh