Microsoft Knowledge Base Email Alertz

KBAlertz.com: (819642) - The article describes how to establish a connection between Microsoft SharePoint Team Services in Project Web Access after you run the SharePoint Configuration Wizard (Stswiz.exe).

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **


Bug Tracking Software
For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.


Community Site



We Send hundreds of thousands of emails using ASP.NET Email



Expert Web Design & Graphic Design
Design44.com

ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 819642 - Last Review: October 16, 2007 - Revision: 4.2

How to configure SharePoint Team Services for Microsoft Project Web Access

On This Page

SUMMARY

The article describes how to establish a connection between Microsoft SharePoint Team Services in Microsoft Project Web Access after you run the SharePoint Configuration Wizard (Stswiz.exe).

MORE INFORMATION

Part 1: Account Permissions

To set account permissions for the SharePoint Team Server and Microsoft SQL Server, follow these steps:
  1. Designate a Windows user account that has Administrative permissions on the SharePoint Team Services computer.

    Note Microsoft recommends that the Microsoft Windows User Accounts have passwords that are set to Password never expires.
  2. Designate a Windows user account that will have db_datareader permissions to the SharePoint Team Services database in SQL Server. To add the db_datareader rights to the SharePoint SQL Server database, follow these steps:
    1. Click Start, point to Programs, click Microsoft SQL Server, and then click Enterprise Manager.
    2. Expand the Security folder, right-click Logins, and then click New Login.
    3. On the General tab, type the name in the form of Domain\UserName in the Name box.
    4. In the Defaults section, change the name of the database to your SharePoint database.
    5. On the Database Access tab, click to select the Permit check box for the SharePoint database.
    6. In the Database Roles area, click to select db_datareader, and then click OK.
  3. Run the PSCOM+ utility to impersonate the accounts for a COM+ application.

    Note Pscomp+.exe is used to create or set the identity of the accounts that will be used to impersonate the component services for Microsoft Project Server.

    To run the PSCOM+ utility, follow these steps:
    1. Double-click Pscom+.exe. The Pscom+.exe utility is located in the Microsoft Project Server\Bin\1033 folder.
    2. On the Microsoft Project Server Com+ Settings menu, type the Windows user account and password (in the form of domain\username) that you created earlier in this article for the SharePoint Team Services Administration Identity (Windows User Account that is an Administrator on the STS Server) and the SharePoint Team Services Database Access Identity (Windows Account that has db_datareader rights in SQL Server).
    3. Click Create\Update Com+ Apps.

      Note You can enter the OLAP Access Identity for the Windows user account that has Administrative permissions to the OLAP Administrators group, or you can defer this for later.

Part 2: Configure Project Server for a Proxy Server

Project Server communicates with SharePoint Team Services by using the XMLHTTP protocol. For Project Server to communicate with the SharePoint Team Services computer successfully, the Project Server computer must be configured to connect through the proxy server, if your organization uses one.

If your organization does not use a proxy server, that information must be configured also. This requirement is true even if Project Server and SharePoint Team Services are installed on the same computer.
  1. On the Project Server-based computer, click Start, click Run, type cmd in the Open box, and then click OK.
  2. Change the folder to the location of Proxycfg.exe.

    For example, type cd C:\Program Files\Microsoft Project Server\Bin.
  3. Type the following command. When you do this, specify the ServerName, the IP address, and the fully qualified domain name (FQDN) of the SharePoint Server in the bypass list. For example, type the following: proxycfg -d -p " YourProxyServer " "local;ServerName;IPAddress; FQDN"

    Note If you are not in a proxy server environment, type NoProxyServer in the YourProxyServer section.
  4. The Proxy Server information will process and write to the registry.
  5. After returning to the command prompt, type iisreset to restart Internet Information Server (IIS).
  6. Try to connect SharePoint Team Services to Project Web Access.
For more information about the configuration of SharePoint Team Services in Microsoft Project Web Access, click the following article number to view the article in the Microsoft Knowledge Base:
322235  (http://kbalertz.com/Feedback.aspx?kbNumber=322235/ ) How to install and configure SharePoint Team Services for Microsoft Project Server on Windows 2000
For more information about the WinHTTP Proxy configuration utility, see the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/ms761351.aspx (http://msdn2.microsoft.com/en-us/library/ms761351.aspx)

APPLIES TO
  • Microsoft Project 2002 Standard Edition
  • Microsoft Office Project Web Access
Keywords: 
kbhowto KB819642
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Be the first to leave feedback, to help others about this knowledge base article.

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please