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)