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.
Thanks for this .. good work .. its nice to see that u r practising what i have thought …
Cheers.
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?
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!
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
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!
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
@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”
Interesting article on how to delete ssp
http://home.dzeee.net/blogs/sp/Lists/Posts/Post.aspx?ID=54
Aneesh, thank you. Your solution worked.