Solved

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

Posted on 2013-01-23
9
891 Views
Last Modified: 2013-01-24
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)
0
Comment
Question by:mmalik15
  • 5
  • 4
9 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 38809383
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
 

Author Comment

by:mmalik15
ID: 38809393
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
 

Author Comment

by:mmalik15
ID: 38809424
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 17

Expert Comment

by:Barry Cunney
ID: 38809443
According to the above KB, installing SQL Server 2005 SP2 is the workaround to this problem
0
 

Author Comment

by:mmalik15
ID: 38809521
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
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 38809547
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
 

Author Comment

by:mmalik15
ID: 38809553
I tried that already renamed the dependency but not worked
0
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 38809602
Reboot the machine and restart all SQL Server services and then lastly try starting the Full Text service
0
 

Author Comment

by:mmalik15
ID: 38813675
wow the restart did work :)
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question