"Unprovisioning Failed:"cannot open database "
SYMPTOMS:
When you tried to delete the SSP from the search admin page, if you are getting
this error.
"Unprovisioning Failed:"cannot open database "<search database >""
OR
If you tried to delete the SSP using the Command line you will get this error
message "cannot open database "<search database >" ".
Resolution:
- Create a new dummy database with the same name(we can see the database name in the error) in the SQL server using the SharePoint admin account.
- Run this command in the command prompt.
"stsadm -o deletessp -title ShareServiceName -force"
- We should be able to delete the SSP in the MOSS server.