?
Solved

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

Posted on 2013-01-23
9
Medium Priority
?
907 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 2000 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

770 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