Solved

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

Posted on 2013-01-23
9
885 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
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now