If the above links do not work, remember that the Feature Pack for SQL is available for both standard bit X86 systems and for bit systems X Select the appropriate X64 files for your server. Click the Next button.
Read the license agreement. In order to continue you must accept the terms; to accept select the I accept the terms in the license agreement radio button and click the Next button to continue the installation. The system displays the Registration Information page shown in the following figure. Complete the information on the Registration Information page and click the Next button to continue.
The system displays the Feature Selection page shown in the following figure. Note that you can view the Disk space requirements for the selected components by clicking on the Disk Cost button.
Click the Next button to continue and the system displays the Ready to Install the Program page shown in the following figure. Click the Install button to continue with the installation. The system displays the progress dialog until the installation is complete. Double click on the MSI file that you downloaded to start the installation. The screens and steps for installing SQL components may change slightly with each new release from Microsoft. Most steps remain the same from version to version.
The system displays the License Agreement page shown in the following figure. On the License Agreement page, read the license agreement. In order to continue you must accept the terms; to accept select the I accept the terms of this license agreement option and then click the Next button. On the Registration Information page, enter your name and company. The system displays the Ready to Install the Program page shown in the following figure. On the Ready to Install the Program page, click the Install button to continue the installation.
Click the Finish button to complete the installation. This process is similar to the steps you followed to create a login for the Report Authors global group earlier in this module. If you are using the Farm Administrator account for all services, this step in not necessary as the Farm Administrator account is already the dbo for the databases.
If you do need to create a login and assign the necessary rights, complete the following steps:. Expand the Security folder and right click on the Logins folder and select the New Login menu item as shown in the following figure. Enter the service OLAP service account information in the Login name field and then select the User Mapping page in the Select a page section of the window. The system displays the User Mapping page shown in the following figure. In the Users mapped to this login section of the upper window, select the checkbox for your Project Server Reporting database.
Click the OK button to complete your entry. With the option set to ON your production system will suddenly suffer a performance decline when SQL Server decides it is shrink-time.
To verify the status of these settings for your databases, you can use the following queries respectively:. To view these properties for all of your databases, use the following query:. This command can run during core business hours when activity on the server is high, affecting performance. Updating statistics synchronously is the default behavior in both SQL Server and Once the system completes updating the statistics, the system executes the query. At the same time a background request tells the database engine to update the statistics automatically as soon as possible, without preventing any query requests.
When the background operation completes, new query requests begin using the new statistics information. To change the status of these settings using SQL Server Management Studio , expand the tree in Object Explorer , locate your database, and right click on the database name and select Properties from the popup menu. The system displays the Database Properties page.
In the Select a Page pane on the left, select Options. Your Database Properties window should appear similar to the following figure. In the Automatic options section, set your desired values by clicking into the value column and selecting your value from the dropdown list. To improve performance, create additional TempDB files.
Create the files on a separate partition from other database files. Now that the installation and initial configuration process is complete, you should verify system functionality and connectivity. If you have not already done so, you must install the Project Professional client on at least one workstation to complete the work in this module. Make sure that you apply the same Service Pack level to both the client and the server.
Log in to your workstation using the account that you designated as the Project Server Administrator, which is the only account that has access to your Project Web App site at this time.
Enter the URL for your new Project Server installation in your browser to verify that your new Project Web App site loads from a system on your network other than the server where it is installed. The system displays your home page as shown in the following figure. Note that the system welcomes you by login name at the top right of the page. You should see a page that has nothing to report in the Reminders section.
Figure 5 - 40 reflects a first-time login to a Project Server instance without any data. During the installation process, Project Server creates a single Project Server user, which is an administrator-level account. It uses the Windows account that you specified during the installation process in Module 04; typically this is the Farm Service Account or the installation account that you are using.
Because your administrator toolkit includes both Project Professional and Project Web App, you must be able to connect to Project Server using Project Professional Before you can use Project Professional in your Project Server environment, you must create a login account for the Project client application on your local machine. If you did not specify your own login account during the installation process, you should log in to your workstation using the account you specified as the Project Server Administrator, or first create an account for yourself on the Project Server instance.
I cover creating resources and users in Module XX. You have two options available to you for creating a Project Server login account. You can do this by launching the Microsoft Project Server Accounts tool under the Office Tools folder in the Office folder from your start menu, or you can launch Project Professional and complete the following steps:. From Project Professional , click the new File tab and select the Info selection on the left hand navigation menu, and then select the Manage Accounts button in the Project Server Accounts section of the page shown in the following figure.
Notice that the Information Page carries two types of content: 1 Navigation tools for accessing Project Server accounts and the organizer, and 2 Summary information about the current project. If you close the default Project 1 file, the system displays only the navigation buttons and the title becomes simply "Information. After you click the Manage Accounts button, the system displays the Project Server Accounts dialog shown in the following figure. Project Server users will notice that Microsoft updated this dialog for Project Click the Add button and the system displays the Account Properties dialog shown in the following figure.
Select the Set as default account option. Click the OK button.
Ignore the warning unless your server requires a secure URL. Click the Yes button to continue if you see this warning. The system redisplays the Project Server Accounts dialog with your new account, as shown in the following figure. In the Project Server Accounts dialog, select the Choose an account option. This is particularly important if you connect to multiple Project Server instances and if you want to completely control the connection state.
MSProjectExperts recommends that you always select the Choose an account option. This provides better control for users who connect to multiple instances and allows for better control of off-line feature use. Create an additional Project Server login account for each instance of your Project Server system, such as for test or training Project Server instances, and then click the OK button. After you create your Project Server login account profiles in Project Professional , exit and then re-launch the software. This is a necessary step because creating your login accounts does not connect you to a Project Server instance.
Stock Image. Reactive Design Patterns Roland Kuhn. This exam validates the skills needed to use Project Standard and Project Professional desktop features excluding Project Server features to manage a project schedule and communicate the project to individuals, teams, and the enterprise. When the process completes, the system displays the Target Application page for the Secure Store Service shown in the following figure. By integrating Project Server with Excel Services, Microsoft has taken the Project Web App interface from offering a paucity of reporting capacity to now providing a limitless data mining experience. Priscilla Oppenheimer. Select the User Mapping page.
The system displays the Login dialog shown in Figure 5 - Because you selected the Choose an account option in the Project Server Accounts dialog, the system allows you to select the Project Server instance for connection. Had you not chosen this option, the system automatically connects to the instance you set as default.
The Login dialog pre-selects the account you set as the Default account in the Project Server Accounts dialog. If you wish to connect using a different login account, click the Profile pick list and select a different account as shown in the following figure.
Note that the first time you connect to a Project Server instance, the Work Offline option is not available. You can select the Computer profile to use Project Professional without connecting to a Project Server instance. Click the OK button to connect to your desired Project Server instance. If the system cannot connect to the selected Project Server instance, it displays the Could not connect to Server dialog shown in the following figure.
If you see the dialog shown in Figure , click the Cancel button to return to the Login dialog and then click the Cancel button in the Login dialog. At this point, you must troubleshoot the cause of the login problem, which is likely one of the four possible reasons previously shown in the Could not connect to Server warning. Now that you have verified basic Project Server connectivity in Project Professional , it is time to confirm that you can exercise basic system input, such as creating, saving, and publishing a project.