2

Deleting a Project Service Application within SharePoint 2010

A couple of days ago I deleted my Project Server Web application because I wanted to recreate it.

When I tried to create a new Project Web App Site I got the following messages:

  • The database specified is already used by another project server. Enter a different server or database name and try again.

projectserver

The first idea that I came up with was deleting the databases from the database server. After deleting the databases I retried my action but the problem was still there.

The next thought that came up in my head was deleting the Project Service Application. I pressed delete on the Manage Service Application Page and got the following error message:

  • Service application cannot be deleted due to existing project sites.

errordeleteprojectserviceapplication

The problem is with the Project Service Application. The Project service application remains a connection with a specific site collection even If you delete the web application or the specific site collection. The only thing you can do to delete the connected site collection (that does not exist anymore) from the Project Service Application by using PowerShell.

First you will have to use PowerShell to retrieve a collection of the sites that are referenced with the service application. Get the ID of the reference you want to remove and than remove that reference .

Let take the first step, get the service application and print the site collections.

$svApp = Get-SPServiceApplication -Name "Project Web App Service Application"
$svApp.SiteCollection 

This will get a complete list of all the associated site collections:

powershelloutcome

Next you can copy the ID and remove it by using the following PowerShell command:

$svApp.SiteCollection.Remove("a09c6964-efc2-4917-9448-ce86d0bc95d3")

And now you can remove the Service Application or recreate the site collection. To remove the service application by using powershell use the following command:

Remove-SPServiceApplication $svApp -RemoveData

Related Posts

Active Directory Picture Synchronization When you have stored the pictures of employees in Active Directory you would like to have the option to synchronize these pictures to their SharePoint...
Deleting the extended web application This post I’m as a reminder because a few days back when I was working on a production environment for one of our clients. I had created an extend...
Office 2010 and SharePoint 2010 Service Pack 1 Two days ago Microsoft released the first Service Pack for the 2010 Office suite. This means there is also a Service Pack for SharePoint 2010. ...
SharePoint 2010 Content Organizer Feature Within SharePoint 2010 Microsoft has changed a lot of the content management features. One of those features is content routing which you can do with...
Creating Metadata Properties through code – SharePoint 2010 When you work on SharePoint project you often see solutions that are built by using the search engine of SharePoint. To perform queries against the s...
Provisioning My Sites SharePoint 2010 In certain scenarios you would like to provision the My Sites of the users before you go live with the environment. Within SharePoint 2010 you have g...

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.