I was getting this WSSSpWebAlreadyLinkedToProject error in the SharePoint error logs. It occurred when publishing a Project plan to Project Server from the Office Project client. The publish action would correctly provision a new workspace, but problems with the workspace were quickly apparent.

Firstly, only the system account had access to the site. For example, I would publish from the Project client using my pwicklund Active Directory account. When things were working, pwicklund would have access to the site that was just published. Well, not this time.

Secondly, I noticed the Site Address was not getting populated in the Project Workspaces page within Project Web Access!

This was definitely a problem because the site was not getting listed on the project workspaces list on the home page of project web access:

So now I'm stuck with an Orphaned workspace that I end users can't see, nor do they have access to!

Well after a while of thinking cap time, I realized what I did wrong. When I created the site template used to create the workspace off of, I created it off of an existing workspace that already had a project plan associated with it. What I had to do was create a new site template off of Microsoft's out of box template – WITHOUT a plan associated with it! So I created a new site with the browser, NOT the MS project client. Then I went into Project Workspace Provisioning Settings and change to the new template, and everything worked!

Hopefully this will save someone a bit of time….

Phil