Cannot create Sharepoint Search Service application


Lately I ran into major issue on Sharepoint Search Service application cannot be created, after doing various iterations, below are the steps to make a clean start and a brand new Sharepoint service application (this was in Sharepoint 2010)

  1. Delete Search Application with data
  2. Remove Search databases if any
  3. stsadm -o spsearch -action stop
  4. stsadm -o osearch -action stop
  5. stsadm -o spsearch -action start
  6. stsadm -o osearch -action start
  7. Create new search using Sharepoint Central Admin GUI
  8. This should create a working Sharepoint Service application
  9. After Step 6 – if you can create Search Service Application using Clean database names without GUID then you can SKIP the below steps
  10. Below Steps are valid ONLY if you have created SP search Service application using Central administration and database names have GUID
  11. Go to the Search Service application topologymodify
  12. Rename crawl and property using modify topology – this can be done only for crawl and property database only (Edit is available only for the 2 database) EditProperties
  13. Click OK after changing the database name
  14. Search Administration database name can be changed using Database attach/detach method
  15. Inform users or do this during sharepoint downtime window
  16. Rename Search application database using backup, detach and attach method by making database offline, after you change the name follow the below powershell to point sharepoint search to the correct database with new name else it will be pointing to old name with GUID
  17. $searchssa=Get-SPEnterpriseSearchServiceApplication -identity “Search Service Application”
  18. $searchssa.Pause()
  19. $searchssa | Set-SPEnterpriseSearchServiceApplication -DatabaseName “Your new Search administration database name without GUID” -DatabaseServer “SqlServer Name”
  20. $searchssa.Resume()
  21. get-spdatabase | Select Name, ID olddbguid
  22. $olddb=get-spdatabase {GUID}
  23. $olddb.Delete()
  24. Run this powershell the database name with guid is gone and it all clean


Hope this solution help someone, you can also see my other sharepoint search resolution – search service is not able to connect to the machine that hosts the administration component.

Please subscribe to my blog for updates