Configure SQL Server and Analysis Services in Project Server 2013
Applies to: Project Server 2013
Topic Last Modified: 2016-05-11
Summary: Configure SQL Server and SQL Server Analysis Services (SSAS) settings prior to installing Project Server 2013.
Before you install SharePoint Server 2013 and Project Server 2013, you must first configure SQL Server and, if you’re planning to use Project Server OLAP cubes, SQL Server Analysis Services. SQL Server Analysis Services must be deployed in Multidimensional mode.
|If you are installing Project Server 2013 to an existing SharePoint Server farm, some of these steps may already be completed.|
Complete the procedures in each section below:
Additionally, depending on the needs of your organization, you may want to do the following:
Create a Project Web App database
Create additional TempDB files
We also recommend that you start the SQLSERVERAGENT service on the instance of SQL Server where your SharePoint Server databases are located. SharePoint Server and Project Server 2013 use the SQL Server Agent service to perform various database cleanup activities.
When you have finished configuring SQL Server and Analysis Services, go to the next article, Install SharePoint Server 2013 (Project Server 2013).
For SharePoint Server and Project Server to work correctly, the associated instance of SQL Server must be configured to enable remote connections using TCP/IP. Use the following procedure to confirm that your instance of SQL Server is configured to allow remote TCP/IP connections.To configure SQL Server 2008 R2 or SQL Server 2012 network settings
Click Start, click All Programs, click Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2012, click Configuration Tools, and then click SQL Server Configuration Manager.
In the left pane, expand SQL Server Network Configuration, and then select the instance of SQL Server where you will be installing Project Server 2013 databases.
In the right pane, ensure the Status for TCP/IP is Enabled.
Project Server 2013 can build OLAP cubes in SQL Server Analysis Services (SSAS) for use in reporting. If you plan to use the Project Server 2013 cube building feature, you must configure the Farm Administrator account to have administrative permissions in SQL Server Analysis Services for the instance of Analysis Services that you will be using with Project Server 2013.To add the Farm Administrator as an Analysis Services server administrator
Open SQL Server Management Studio. In the Connect to Server window, connect to the instance of Analysis Services that you are using with Project Server 2013.
In SQL Server Management Studio, in Object Explorer, right-click your Analysis Services instance name, and then click Properties.
On the Analysis Services Properties page, in the Select a page pane, click Security.
On the Select Users, Computers, or Groups page, type the name of the Farm Administrator account.
Click OK. The Farm Administrator account appears in the Members list.
Both Project Server 2013 and SharePoint Server 2013 make extensive use of TempDB during SQL transactions. To optimize performance, create additional TempDB files.
As a rule, create an additional TempDB file for each processor (core) in the computer that is running SQL Server. Create the files on a separate partition from other database files.