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:
- 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. - 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:
- Click Start, point to
Programs, click Microsoft SQL Server, and
then click Enterprise Manager.
- Expand the Security folder,
right-click Logins, and then click New
Login.
- On the General tab, type the name in
the form of Domain\UserName in the Name
box.
- In the Defaults section, change the
name of the database to your SharePoint database.
- On the Database Access tab, click to
select the Permit check box for the SharePoint
database.
- In the Database Roles area, click to
select db_datareader, and then click
OK.
- 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:
- Double-click Pscom+.exe. The
Pscom+.exe utility is located in the Microsoft Project Server\Bin\1033 folder.
- 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).
- 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.
- On the Project Server-based computer, click
Start, click Run, type
cmd in the Open box, and then click OK.
- Change the folder to the location of Proxycfg.exe.
For example, type cd C:\Program Files\Microsoft Project
Server\Bin. - 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. - The Proxy Server information will process and write to the
registry.
- After returning to the command prompt, type
iisreset to restart Internet Information Server
(IIS).
- 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:
APPLIES TO
- Microsoft Project 2002 Standard Edition
- Microsoft Office Project Web Access
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