Solved

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

Posted on 2013-01-23
9
882 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

760 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

21 Experts available now in Live!

Get 1:1 Help Now