Sometimes things go wrong with the SSP (life without it in SharePoint 2010 shall be interesting…) If you have one that will not delete, gets stuck in an “unprovisioning state”, cannot be opened or similar try this extra flag:
“Stsadm -o deletessp -title SSPNAME -force“.
The -force will normally delete the entry even if there are errors occurring.
IF you’ve worked with SharePoint for any amount of time you know that is not always the word one would use to describe your experiences. Sometimes that command just does not work and you end up with a lingering SSP. To resolve you need to identify the GUID for the problem SSP and use STSADM -o deleteconfigurationobject -id “id retrieved from object table” to remove this/these item/s from the configuration database.
What’s the GUID? Use the following procedure to identify the Shared Services GUID:
- Login to the SQL server.
- Open SQL Management Studio and expend Databases.
- Expand Configuration Database & Tables.
- Open table for dbo.object.
- Execute the following query in query analyzer: SELECT * FROM [SharePoint_Config].[dbo].[Objects]where name like ‘%SharedServices%’ The results should look like this:
A2B1EC50-7134-40D1-9D97-0D54E129AE70 1AAB936C-E65C-4829-9683-5CCF5BAB90B0 3ACD71A5-B35A-44F1-B524-F90FFEA1AACE SharedServices1_Search_DB
7BB6D64A-E954-4E55-B7CE-15F9AA071748 FB6E9959-5209-44FB-83A4-0A51C31F7A02 3ACD71A5-B35A-44F1-B524-F90FFEA1AACE SharedServices2_DB
A9013685-0830-43A9-925A-7875A10DDA82 9D95E78B-FA6F-4349-AD9A-43BD3EF44E99 43DAD086-2C32-4ECF-B545-9FC63D80698B SharedServices2
- Copy the ID of object referenced in objects table of configuration database.
- Open command prompt and changed directory to C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12BIN> and executed following command to delete the Shared Services using the ID which was copied: Stsadm -o deleteconfigurationobject -id “id retrieved from object table”