How to fix the error when restarting Windows SharePoint Services Search

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

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.

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: 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