"Unprovisioning Failed:"cannot open database "

  • Article

 

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.