sql server 2005 Full - Text Search Service dependency deleted (objectExplorer)

I m trying to backup a database but i get a message relating to Full- Text Search is stopped. When I try to start it I get this message

Unable to start service MSFTESQL$SQL_2K5 on server ....

Additional Information : Service Dependency Deleted(objectExplorer)
mmalik15Asked:
Who is Participating?
 
Barry CunneyConnect With a Mentor Commented:
What Windows Server does this reside on?
What other SQL Server services are running - check in services.msc?

It may be Problem 3 from this KB
http://support.microsoft.com/kb/936302
0
 
mmalik15Author Commented:
I m running sql server 2005 on windows 7 64 bit machine. I also have sql server 2008 on the system and i m running analysis services n sql server agent. etc
0
 
mmalik15Author Commented:
version of SQL

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

Do you think installing sp2 might help?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Barry CunneyCommented:
According to the above KB, installing SQL Server 2005 SP2 is the workaround to this problem
0
 
mmalik15Author Commented:
I have installed both sql server 2005 sp2 and sp3 but still getting the error. I have seen the error details below

"   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
"
0
 
Barry CunneyCommented:
This is another workaround I have seen potsed
http://maniish.wordpress.com/2010/06/24/service-dependency-deleted-in-sql-server-when-enabling-full-text-search/

Not sure if it is an official workaround so back up registry first
0
 
mmalik15Author Commented:
I tried that already renamed the dependency but not worked
0
 
Barry CunneyCommented:
Reboot the machine and restart all SQL Server services and then lastly try starting the Full Text service
0
 
mmalik15Author Commented:
wow the restart did work :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.