Problem with linking WSS site and Project in EPM

[bill_murphy]

We are experiencing a problem with Project Server and the WSS sites
connection.
1.The environment
There are three individual servers for SQL, SPS and EPS

The client can access Project data from the EPM server and also access
it via PWA
The SPS portal pages can also be viewed from the client.

A proxy server exists and Internet Explorer has been set up to bypass
the proxy for the EPM and SPS Server names

The WSS site creation account for the Project Server has been set up as
a Domain account and has local administrator on SPS, EPM and SQL.

2.The Changes to the Project WSS Template
We have used a copy of the Project Server WSS template to create a new
SPS/WSS template with some customisation:
· Changes were made to the columns and views in the Risk and Issue
lists
· Some banner changes and general cosmetic look and feel
· The Project View web part was added to the display the task for the
project

3.The Process
· The new template is used to generate a WSS site linked to SPS
· The PWA access is opened using an Windows account that is an
administrator in PWA
· The generated site is linked to a project in EPM using the
"Manage Sharepoint Sites" option in Admin > "Manage Windows
SharePoint Services" (the connection to the WSS server is vailid)

4.The Problem
The process for link the site produces an error
'An error occured when updating the team Web site address in the
Project Server database'
What causes this error so we can fix it?

 

[Gary L. Chefetz \(MVP\)]

Most often caused by the WSSAdmin account in Com+ not having the correct
permissions on the database.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
We are experiencing a problem with Project Server and the WSS sites
connection.
1.The environment
There are three individual servers for SQL, SPS and EPS

The client can access Project data from the EPM server and also access
it via PWA
The SPS portal pages can also be viewed from the client.

A proxy server exists and Internet Explorer has been set up to bypass
the proxy for the EPM and SPS Server names

The WSS site creation account for the Project Server has been set up as
a Domain account and has local administrator on SPS, EPM and SQL.

2.The Changes to the Project WSS Template
We have used a copy of the Project Server WSS template to create a new
SPS/WSS template with some customisation:
· Changes were made to the columns and views in the Risk and Issue
lists
· Some banner changes and general cosmetic look and feel
· The Project View web part was added to the display the task for the
project

3.The Process
· The new template is used to generate a WSS site linked to SPS
· The PWA access is opened using an Windows account that is an
administrator in PWA
· The generated site is linked to a project in EPM using the
"Manage Sharepoint Sites" option in Admin > "Manage Windows
SharePoint Services" (the connection to the WSS server is vailid)

4.The Problem
The process for link the site produces an error
'An error occured when updating the team Web site address in the
Project Server database'
What causes this error so we can fix it?