.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

StartResourceService: Failed to start SQLSERVERAGENT service

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
 

Dear all,

We have problem with SQL Server Agent service running on Fail-Over Cluster at Windows Server 2003 R2 Enterprise Edition. Agent service won't started. These error founded in Event Viewer :


System Event Log
================
Event Type: Error
Event Source: ClusSvc
Event Category: Failover Mgr
Event ID: 1069
Date:  1/11/1990
Time:  5:48:55 PM
User:  N/A
Computer: JSXDBET1
Description:
Cluster resource 'SQL Server Agent' in Resource Group 'MSDTC Group' failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Application Event Log
=====================
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Failover
Event ID: 53
Date:  1/11/1990
Time:  5:48:55 PM
User:  N/A
Computer: JSXDBET1
Description:
[sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1


For more information, see Help and Support Center at


View Complete Post


More Related Resource Links

sql server start service error "The request failed or the service didn't respond in a timely fashio

  
I cannot start sql server 2008 after repair windows. sql server (MSSQLSERVER) not start dialog message "The request failed or the service didn't respond in a timely fashion.Consult the event log or other applicable error logs for details"  I open even log (control panel >> administration >> event viewer) find error log with sql server it notice Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(failed to retrieve text for this error. Reason: 1815) I open file ERRORLOG.5 but I don't understand where I should fix?  I copy errorlog.5 on this webboard  Please help me! thank you   2010-08-20 08:16:52.89 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)  Jul  9 2008 14:43:34  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) 2010-08-20 08:16:52.89 Server      (c) 2005 Microsoft Corporation. 2010-08-20 08:16:52.89 Server      All rights reserved. 2010-08-20 08:16:52.89 Server      Server process ID is 2248. 2010-08-20 08:16:52.89 Server      Authentication mode is MIXED. 2010-08-20 08:16:52.89 Server  &

SQL2008 Installation error Service SQLBrowser start request failed

  
This relates to the Enterprise SQL 2008 Failover Cluster installation. After the initial setup reaches a near completion point the Setup receives the following Error has occurred: Service 'SQLBrowser start request failed. Click Retry to retry the failed action, or click Cancel to cancel this action and continue setup.

The SQL Server service failed to start

  
Hi, I'm trying to install SQL Server2005 Express but get the following error:       The SQL Server service failed to start Attempts to start the service manually have failed. Pse advice. Thanks,tonyKM #######################################################Error Signature:####################################################### EventType: sql90setup  P1 : do_sqlscript  P2 : 0x733fP3: sqls__service__start P4 : 0x42b  P5 : sqlsetuplib_service.cpp@301 P6 : sqlca.dll@2005.90.1399.0 P7 : sqlrun_sql.msi@9.00.1399.06 #######################################################LOG File####################################################### Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time            : Mon Dec 05 17:18:40 2005  MKE303 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.Machine         : MKE303 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install        

The SQL Server(2005 express) service failed to start. Error 29503

  

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.

Initially the SQL Server was running over there, later one day it stopped. When trying to start manually I got "The process terminated unexpectedly" error. Tthen I uninstalled it and tried to install again, but got "Error 29503. The SQL Server service failed to start" error while installation and installation rolled back. If I install it using Local System and without "Enable User Instance" I get same error but after multiple retry it started. However my desktop application is not running and giving error message "Failed to generate a user instance of SQL Server due to a failure process for the user instance. The connection will be closed".

I tried "sp_Configure .......... " and "Reconfigure" to enable user instance but still got "Failed to generate......" error.

Another problem is that SQL Server service starts in multiple retry.

I have tried most of the forum solutions however I am still getting the same error in my desktop application. Mos

The SQL Server(2005 express) service failed to start.

  
subject:The SQL Server(2005 express) service failed to start.

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.


I have tried most of the forum solutions however I am still getting the same error in my desktop application. Most of the experts on the forum usually ask for the log where the reason might be. So I am pasting my error log below.
I went through the whole log but I couldnt figure out anything in this. Can anyone help us out trying to figure out whats wrong by checking this below.
Its been a week I am trying to figure out whats going on. 


=== Verbose logging started: 9/13/2010  19:14:48  Build type: SHIP UNICODE 3.01.4001.5512  Calling process: c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (04:38) [19:14:48:875]: Resetting cached policy values
MSI (c) (04:38) [19:14:48:875]: Machine policy value 'Debug' is 0
MSI (c) (04:38) [19:14:48:875]: ******* RunEngine:
           ******* Product: c:\83b6a4866f90056a547

SP2 failed only on the Database engine; the MSSQLSERVER service cannot start

  

  I tried to apply the SP2 on a newly installed SQL Server 2005 Developer edition. The installation failed and the MSSQLSERVER service does not start. I work on 32 bits Windows Server 2003 Standard Edition SP1 with all the patches up to date. I downloaded SQL Server 2005 SP2 on March 15, 2007.

Here are the error messages from 2 of the log files:

Summary.txt:

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number              : 29534
Error Description         : MSP Error: 29534  Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (-2146885

MSSQL$WINCC service which failed to start

  
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7001
Date:  28/10/2010
Time:  08:52:57
User:  N/A
Computer: QC
Description:
The SQLAgent$WINCC service depends on the MSSQL$WINCC service which failed to start because of the following error:
%%0

MSSQL$WINCC service which failed to start

  
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7001
Date:  28/10/2010
Time:  08:52:57
User:  N/A
Computer: QC
Description:
The SQLAgent$WINCC service depends on the MSSQL$WINCC service which failed to start because of the following error:
%%0

Web analytics service failed to start : access denied

  

I came a cross an error in my sharepoint environemnt whic indicates that Web analytics service  fails to start.

Web analytics service failed to start : access denied

I have everything up and running, is there a special service with a special privileges that need to be setup for this service?

Thanks in advance


Custom tool error: Failed to generate code for the service reference 'CompanyService'. Please che

  

A little background because I feel I have an out of the ordinary architecture in place and don't know if this is contributing to the problem. 

We have an existing ASP.net application that is undergoing expansion.  The new functionality is all written in Silverlight 4.  As part of that expansion I gutted all the old Linq to SQL and put Entity Framework 4 into place.  To do this I created a standard .net Class Library and added my edmx files there.  Naturally, the business entities created by this cannot be used in Silverlight.  So I created a Silverlight Class Library and added all the business entities to that Silverlight Class Library as linked files.  I changed the name space to be the same.

So I have the following assembly / namespaces

Company.Project.Dal.csproj / Company.Project.Entities (.net 4 class library)

Company.Project.Entities.csproj / Company.Project.Entities (SL4 class library)

With this architecture I was able to share my business entities with my SL enabled web services, my asp.net projects, my silverlight projects.  Really it's a beautiful thing.

Once this was done I added "message" classes to Company.Project.Dal and again shared them with the other entites using linked files.  These messages are things like MyObjectRequest; they are class

Cannot Start Search service.

  

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (9ca20163-f0f2-412c-a3ea-927a20205285).

Reason: Could not access the Search service configuration database 

Techinal Support Details:
Microsoft.Office.Server.Search.Administration.DatabaseException: Could not access the Search service configuration database   ---> System.Runtime.InteropServices.COMException (0xC004122D): Could not access the Search service configuration database 
   at Microsoft.Office.Server.Search.Administration.MSSITLB.IGatherApplications2.Mount(String bstrName)
   at Microsoft.Office.Server.Search.Administration.GathererApplication.ProvisionGathererApplication()
   at Microsoft.Office.Server.Search.Administration.GathererApplication.Provision()
   at Microsoft.Office.Server.Search.Administration.OSSIndexGathererApplication.Provision()
   at Microsoft.Office.Server.Search.Administration.SearchApi.<>c__DisplayClass20.<AddApp>b__1f()
   at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode, Boolean useCurrentSecurityContext, Int32 versionIn)
   --- End of inner exception stack trace ---
  

Workflow "Failed on Start (retrying)" when new item created by BizTalk SharePoint Adapter

  

We've been using the BizTalk SharePoint Adapter to load various different contents into a MOSS 2007 Document Library. The library has a Microsoft Office SharePoint Designer 2007 workflow (sequential workflow created in Designer) which starts automatically when a new item is added to the Document Library. Or, at least, it eventually starts automatically.

 

For some unknown reason--and this is what we're hoping some of you may have some ideas on--the workflow fails to start on the first try, producing the "Failed to Start (retrying)" message. When the timer job comes back the second time, the workflow starts successfully, but this causes us to loose five minutes of potential work time (not to mention making us look bad to the VPs and CTO because they see the failure message).

 

In checking the log, I find the following pair of error messages each time the "Failed to Start (retrying)" status occurs:

 

08/27/2007 13:49:43.24  w3wp.exe (0x0CA0)                        0x1438 Windows SharePoint Services    Workflow Infrastructure        72fs Unexpected RunWorkflow: Microsoft.SharePoint.SPException: <Error><CompilerError Line="1" Column="1" Text="The root activity type is invalid.&q

VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit

  

I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines


WCF Service: takes very long time to start up

  
Hi, What could be the reasons, why my WCF service takes up to 40 seconds to get started? My service class is set to [ServiceBehavior(InstanceContextMode = InstanceContextMode.Single)] I am running a thread inside this class. The WCF service gets initialized and opened within the context of this thread. The Initialization: private void InitializeWCFService() {      // initialize servcie base addrresses      this.SetupBaseAddresses();      //MetaData behaviour : allow HttpGet      ServiceMetadataBehavior metaDataBehavior = new ServiceMetadataBehavior();      metaDataBehavior.HttpGetEnabled = true;      // initialize service host instance      this.seviceHost = new ServiceHost(this, this.httpBaseAddress, this.tcpBaseAddress);      // add service endpoints and behavior.      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Tcp), EndpointName);      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Http), EndpointName);      this.seviceHost.Description.Behaviors.Add(metaDataBehavior);      // MEX endpoint      this.seviceHost.AddServic

While calling Web service gets exception "The request failed with HTTP status 401: Unauthorized"

  
Hi All, I created a ASP.NET web service, which was hosted on default visual studioserver, and on excecution of webservice it run .exe file which in turn update xml file. Now i hosted this webservice on IIS 6.0 server, and when i run the service, itfails to execute the exe.When i run it on debug mode, i never get any exception.Code...public string HelloWorld()    {        Process myProcess = new Process();        try        {            myProcess.StartInfo.UseShellExecute = false;            // You can start any process,             myProcess.StartInfo.FileName = @"E:\Projects\some.exe";            myProcess.StartInfo.CreateNoWindow = true;            myProcess.Start();            myProcess.Close();            myProcess.Dispose();            return "Suceess";         }&n

Unable to start user profile synchronization service

  
Hello, I have the following problem. user profile synchronization service doesn't start up, with the following error in log: The service encryption keys could not be found. User Action Verify that the service account has permissions to the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Forefront Identity Manager\2010\Synchronization Service If the problem persists, run setup and restore the encryption keys from backup. Permissions for registry are availabele. Thank you.    

Claims to windows token service wont start in Central administration

  
Not sure if this is a bug or some setting I just dont understand but I cannot get the claims to windows token service from manage services to show as started. When I click start I get this error in the event viewer: An attempt to start/stop instance of service Claims to Windows Token Service on server <SERVERNAME> did not succeed. Re-run the action via UI or command line on the specified server. Additional information is below. c2wts (DOMAIN\sp_farm) I have searched and searched for an answer. This thread http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/6b865ead-970b-4460-9dcf-1cc6d6d8530b talks about needing a connection to the internet, but my server is connected to the internet so i think i can rule that out. Also I have read that c2wts depends on the crypto service. I have run this command with no success: sc config c2wts depend= cryptsvc I can start the c2wts service through services.msc and it is succesful. But central administration still shows it is stopped. I have also re-run the installer in repair mode, and re-run the initial configuration wizard, maintaining all of the same settings as the previous installation. That didn't help. Basically, I'm out of ideas and I cant find much about this on the web. Any ideas?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend