How to fix the error when restarting Windows SharePoint Services Search

  • Article

If you stop the “Windows SharePoint Services Search” and start it again using:

  • Central Administration=>Operations=>Services on server=>Windows SharePoint Services Search=>Stop
  • Central Administration=>Operations=>Services on server=>Windows SharePoint Services Search=>Start

You might get the following error:

  • database_name on np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query contains user-defined schema.  Databases must be empty before they can be used.  Delete all of the tables, stored procedures and other objects or use a different database.

You can fix the problem by deleting the database in the SQL Server:

  • Stop the SQL Server Express Services: Start => All Programs => Administrative Tools => Services => SQL Server (SQLEXPRESS) => Right click Stop
  • Delete the following file
    C:\Windows\SYSMSI\SSEE\MSSL.2005\MSSQL\DATA\WSS_Search_ Servername.mdf
    C:\Windows\SYSMSI\SSEE\MSSL.2005\MSSQL\DATA\WSS_Search_ Servername_log.LDF
  • Restart SQL Server Express Services: Start => All Programs => Administrative Tools => Services => SQL Server (SQLEXPRESS) => Right click Start

Restart the Windows SharePoint Services Search Again:

  • Restart the Windows SharePoint Services Search: Central Administration=>Operations=>Services on server=>Windows SharePoint Services Search=>Start
  • In the Configure Windows SharePoint Services Search Service Settings page, In the Search Database section, type a new database name in the Database Name field. Click Start. (Note: You might get an error if you use the old database name)

Comments

  • Anonymous
    September 07, 2010
    Hello, I had this problem and now it's fixed. I would just like to know however, that it might be simpler to just  go to Central Administration and Services on Server and under SharePoint Services Search, just append v2 to the database name to change the name. Sharepoint will automatically create a new database in SQL, assign the appropriate permissions to it and the service will get started once again.

  • Anonymous
    April 12, 2012
    Hello This problem of not being able to use the existing database, is it solved in Sharepoint 2010? I would like that my old indexing content is used too. Thanks