Abhishek Bhowmick | SharePoint Blog

Unable to delete Shared Services in Sharepoint

Posted in Sharepoint by Abhishek Bhowmick on August 16, 2008

DESCRIPTION: Unable to Delete Shared Services when it’s database is deleted from SQL server.

SYMPTOMS: Unable to delete Shared Services. There are still some objects which are dependent on configuration database and on project serve, due to which users are unable to delete SSP. Manually deleting of SSP using stsadm -o deletessp -title “ssp_name” command also shows same error.

ERROR MESSAGE: “An object in the SharePoint administrative framework, “SharedResourceProvider Name=SSP Parent=SPFarm Name=MOSS”, could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: ProjectPSISharedApplicationTimerJob Name=Project Server Synchronizing Job for ‘SSP’ Parent=ProjectApplicationService Name=ProjectApplicationService”

RESOLUTION: ° Identify the GUID for the problem SSP. ° Use STSADM -o deleteconfigurationobject -id “id retrieved from object table” to remove these items from the configuration database.

Use the following procedure to identify the Shared Services GUID:

Login to SQL server. ° Open SQL Management Studio and expend Databases. ° Expand Configuration Database & Tables. ° Opened table for dbo.object. ° Executed following query in query analyzer:  SELECT * FROM [MOSS_CFG_CA_01].[dbo].[Objects]where name like ‘Name of the Shared Services’. ° Copy the ID of object referenced in objects table of configuration database. ° Open command prompt and changed directory to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN> and executed following command to delete the Shared Services using the ID which was copied: Stsadm -o deleteconfigurationobject -id “id retrieved from object table”

Shared Services should be deleted from the Cenral Administration.

Advertisements

25 Responses

Subscribe to comments with RSS.

  1. Iqbal Sayed said, on November 25, 2008 at 11:33 am

    Thanks for this .. good work .. its nice to see that u r practising what i have thought …

    Cheers.

  2. Franklin said, on December 16, 2008 at 7:18 pm

    When I click “Grant or configure shared services between farms” I get an error:An unhandled exception occurred in the user interface.Exception Information: The specified account name is invalid.
    Parameter name: account

    I get this same error if I try to click on edit properties in the drop down for the parent ssp in Manage this Farm’s Shared Services as well.

    If I try to delete the ssp using command line I get: cannot delet the parent.
    If I try to use the delete the configuration objet command as you suggest I get the same “cannot delete parent ssp” error.

    Any suggestions?

    • Fareed said, on June 18, 2009 at 9:07 am

      stsadm -o deletessp -title -force

  3. Abhishek Bhowmick said, on December 23, 2008 at 5:07 am

    I regret the delay in replying to this post as something else was taking my attention for the past few days. Somethings that I can think of as per the error symptoms:

    a. Verify if the user account that runs the SSP is not disabled in the Active Directory

    b. If the user account is deleted from the Active Directory then re-creating them may give us some luck.

    You may also try the following:

    c. Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. Execute the following command on all servers in the farm: stsadm -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword

    d. Update the password for the account that is used to run the Office SharePoint Server Search service. Execute the following command: stsadm -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword

    e. If the server farm is configured to use single sign-on then update the password for the account that is used by the Microsoft Single Sign-On Service. Follow these steps to get this done: Click Operations in SharePoint 3.0 Central Administration, click Service accounts under Security Configuration, under Windows service, click Single Sign-On Service, under Configurable, specify the password and then click OK.

    f. Update the password for the default content access account that is used by the Office SharePoint Server Search service. Follow these steps: Open SharePoint 3.0 Central Administration, click the link to the SSP Web application under Shared Services Administration, under Search, click Search settings and then click Default content access account, specify the password to use for the content access account and then click OK.

    Hope this helps!

  4. Aneesh said, on December 27, 2008 at 2:47 am

    I came accross the same issue and was not able to resolve the issue following any of the above instructions.
    In my case i was getting the error “Cannot delete the parent Shared Services Provider”.

    So I went to central admin > Application Management > Manage Shared Services between Farms > and disbaled “This farm will provide shared services to other farms” and enabled “This farm does not participate in shared services between farms”.

    Once these steps were followed, I was able to delete the SSP.

    Hope this issue does not trouble anyone anymore 😉

  5. Abhishek Bhowmick said, on December 27, 2008 at 3:33 am

    That is another way to look at it. Sounds cool! Now that is what I call active participation to this blog. Contributions are highly appreciated!

  6. JoeStuck said, on January 27, 2009 at 12:06 am

    In tried to get Excel Services going by clicking on it, and the web page cant be found. Discovered that errors in the event viewer have been stacking up for weeks now. Tried to create a new SSP. That failed. Now trying to delete that SSP and its stuck in provisioning. I’d like to use the solution above, but unfortunately no db access where I’m at 😦

  7. Abhishek Bhowmick said, on January 27, 2009 at 2:19 am

    @JoeStuck Unforunately this solution is only applicable if you have a database access. However, if you do not have access to the database then you may have to get in touch with the db administrators to get you this information. I am not sure if you have tried this basic troubleshooting but you should try this too. Run this command from the SharePoint Server: “stsadm -o deletessp -title “SharedServiceName” -deletedatabases”

  8. Sarabjeet Singh said, on March 17, 2009 at 8:37 pm

    I tried following the above steps to fix the issues however in end got to a situation where shared services show as unprovisioning however the problem shows up as access is denied because database is not available.

  9. Dip said, on April 17, 2009 at 2:47 am

    Interesting article on how to delete ssp
    http://home.dzeee.net/blogs/sp/Lists/Posts/Post.aspx?ID=54

  10. chris b said, on June 3, 2009 at 8:10 pm

    Sadly no, I had this error, ran the deleteconfigurationobject command, and now my central admin still has a link to the old ssp, and I get the same errors as Franklin now. Gonna have to wipe the farm and reinstall because it’s completely hosed.

  11. chris b said, on June 3, 2009 at 8:12 pm

    Oh it’s not a link to the old ssp it’s just showing up on the leftnav with no link. But shared services administration doesn’t work.

  12. Ali Khan said, on June 10, 2009 at 8:37 pm

    Aneesh, thank you. Your solution worked.

  13. Sylvia Brown said, on January 14, 2010 at 1:49 pm

    Great info, I will definitely put it to use! I always learn something here. Keep it coming!

  14. Cannot Uninstall said, on March 2, 2010 at 4:19 am

    I am a frequent reader of your blog and just wanted to inform you that I really love your blog.

  15. Luckyme said, on July 1, 2010 at 5:03 am

    This post saved me so much time…. all I have to say.

  16. Brian Fisk said, on October 7, 2010 at 9:42 pm

    Thank you! Works

  17. […] to this blog I was able to delete the application – rather than dive in to the DBs as that article said I […]

  18. […] to this blog I was able to delete the application – rather than dive in to the DBs as that article said I […]

  19. hahahahaha said, on March 23, 2012 at 11:37 am

    Bengali baba Ha Ha Ha Ha Ha

  20. Lauren said, on September 16, 2012 at 4:47 pm

    Good respond in return of this issue with real arguments and
    describing the whole thing concerning that.

  21. Alissa said, on March 5, 2013 at 10:54 am

    Awsome website! I am loving it!! Will be back later to read some

    more. I am bookmarking your feeds also.

  22. Thanks , I have recently been searching for information

    about this topic for ages and yours is the best I’ve came

    upon till now. But, what concerning the bottom

    line? Are you positive in regards to the source?

  23. virtual dj said, on May 23, 2013 at 8:52 am

    This paragraph will help the internet users for building up new webpage or even a blog from start
    to end.

  24. Water Lines in Brookfield said, on June 18, 2013 at 7:41 pm

    Hello, its pleasant paragraph about media print, we all be aware of media is a fantastic source of
    data.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: