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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQLAgent not starting - error

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

Below is the error i receive when my i log into my server. This happened after i installed windows system restore and restarted and updates were applied as well.


Really not sure if the system restore that caused this or the updates that were applied.

Can any one assist me? Other SQL instances run but the most important that manages my MSDE maintenance database has shutdown

 OS is Windows Server 2003 Ent edition

SQLAgent here is MSDE.

Event Type:    Error
Event Source:    MSSQLServer
Event Category:    Server
Event ID:    17055
Date:        10/8/2010
Time:        4:01:00 PM
User:        N/A
Computer:    SERVER2
17310 :
SqlDumpExceptionHandler: Process 4052 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0000: 9e 43 00 00 10 00 00 00   zC......
0008: 09 00 00 00 4f 00 49 00   ....O.I.
0010: 4c 00 44 00 41 00 54 00   L.D.A.T.
0018: 41 00 32 00 00 00 00 00   A.2.....

View Complete Post

More Related Resource Links

How to Get Error Message from Job History if SQLAgent Job Fails

Hello, I am using "last_run_outcome" value = 0 (fail) or 1 (pass)  from sysjobsteps to identify if the job has failed. So if the job has failed, can I get the Error Message from SQL ? (which we can see in Job History). Thanks, Prabhat

Error starting SQL Server Agent - Could not load the DLL xpstar90.dll. Reason: 126

AD Service account password was changed.  Now the SQL Server Agent (MSSQLSERVER) will not start even after updating the password.  Have no access into the databases.  Log files say "Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)."  Service Account has Full rights on system.  Any help in solving the problem would be great.

Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.

I'm getting the following error on two of my SQL Servers - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f] The solution is to unflag the use of NT Fibers.  However, our software application provider is advising us against doing this.  Is there another fix anywhere that I could get my hands on - another solution? Thanks in advance.

activeX error when starting a workflow from inside Microsoft Word


I have a Word 2007 document hosted on a local intranet SharePoint 2007 Server.
When i open the document inside Word 2007 and start a Collect Signature workflow (the word document has some signature lines included), the following ActiveX error si thrown:

Microsoft Office InfoPath
One or more ActiveX controls could not be displayed because either:

1) Your current security settings prohibit running ActiveX controls on this page, or
2) You have blocked a publisher of one of the controls.

As a result, the page might not display correctly.

I managed to find out that the error is generated because of the security level regarding ActiveX controls set on the INTERNET zone.
In the internet zone, all ActiveX controls are restricted to run, but in the LOCAL INTRANET zone are allowed.
Our company security policy does not permit changing the ActiveX settings in INTERNET zone.

If i navigate to the sharepoint site in Internet Explorer, the site is seen correctly in the LOCAL INTRANET zone

Can somebody give me a solution to be able to start the workflow process, without modifing security settings on the internet zone and without upgrading to O

Error message when starting reportserver and reports on localhost


 Hi ,

I am getting the following error when trying to start 1. http://localhost/ReportServer and 2. http://localhost/Reports.



Server Error in '/ReportServer' Application.

Failed to access IIS metabase.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Error Starting Script Editor in SSIS


I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

FIMSynchronizationService starting error: Missing object from Sync DB?


Hi everyone,

I've been trying to solve some issues I've been having with the user profile service. I had it running great without problems. However I had to change a setting, then everything just stopped working and never came back alive. I wound up deleting the service profile then recreating it however now I'm just getting a whole different error. I tried searching the internet but couldn't find any solutions. Anyway here is the error I receive in the application log:


The server encountered an unexpected error and stopped.
 "ERR: MMS(4420): sql.cpp(5580): Query (select count(*) from [mms_management_agent]) performed with error
ERR: MMS(4420): sql.cpp(5633): Invalid object name 'mms_management_agent'.
ERR: MMS(4420): sql.cpp(5641): hrError: 0x80040e37, dwMinor: 208
ERR: MMS(4420): sql.cpp(5796): SQL error: 42S02, native: 208
BAIL: MMS(4420): sql.cpp(2897): 0x80040e37
BAIL: MMS(4420): sql.cpp(4114): 0x80040e37
ERR: MMS(4420): sql.cpp(5580): Query (select fixed_schema_version_number from [mms_server_configuration] ) performed with error
ERR: MMS(4420): sql.cpp(5633): Invalid object name 'mms_server_configuration'.
ERR: MMS(4420): sql.cpp(5641): hrError: 0x80040e37, dwMinor: 208
ERR: MMS(4420): sql.cpp(5796): SQL error: 42S02, native: 208
BAIL: MMS(4420): sql.cpp(2897): 0x80040e37
BAIL: MMS(4420): sql.cpp(2738): 0x80040e37

Starting New SSIS Package Error 0x8002802B "Element not found"



When I attempt to create a new SSIS package I get the following message:


Failed to save package file "C:\Documents and Settings\username\Local Settings\Temp\temp28.tmp" with error 0x8002802B "Element not found.''.


Has anyone any idea how to fix this issue?  I have all of the latest service packs for VS, Windows, SQL.



Error warming up the worker process. - Starting worker process threw - Inner Exception: System.Runti


Can anybody guide me how to resolve this on my production server,



Error warming up the worker process. - Starting worker process threw - Inner Exception: System.Runtime.Remoting.RemotingException: 4 arguments were passed to 'Microsoft.SharePoint.UserCode.ISPUserCodeWorkerProcessProxy::Initialize'. 3 arguments were expected by this method.    Server stack trace:      at System.Runtime.Remoting.Messaging.Message.CoerceArgs(MethodBase mb, Object[] args, ParameterInfo[] pi)     at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)    Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.SharePoint.UserCode.ISPUserCodeWorkerProcessProxy.Initialize(Int32 appDomainCount, Boolean alwaysRecycleAppDomains, Byte[] salt, Boolean logRequests)     at Microsoft.SharePoint.UserCode.SPUserCodeWorkerProcess.InitializeWorkerProcess(ISPUserCodeWorkerProcessProxy workerProcessProxy, Boolean alwaysRecycleAppDomains, Byte[] saltBytes, Boolean logRequests)     at Microsoft.SharePoint.UserCode.

"Windows SharePoint Services Web Application" service is showing 'Error starting'.


I just installed MOSS SP2 and ran the config wizard on the server.
I am facing issue with our farm. Found that "Windows SharePoint Services Web Application" is in a problem.

I tried below commands:-
stsadm -o provisionservice -action stop -servicetype spwebservice -servicename ""
stsadm -o provisionservice -action start -servicetype spwebservice -servicename ""
But getting error:- Provision of service failed. Additional information: 1387.

Checked eventvwr and found below error log:-
Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Topology
Event ID: 7034
Date:  10/21/2010
Time:  5:16:10 AM
User:  N/A
Computer: <Servername>
An attempt to start/stop instance  of service Windows SharePoint Services Web Application on server <servername> did not succeed. Re-run the action via UI or command line on the specified server.

None of the sites are working and I cannot see anything in the IIS folder nor in the IIS manager. All application folders are missing. But, I can see all the sites & Content databasesin the Central Admin.

Can someone please help?


SQL 2005 Cluster Error (SQL Server Cluster Resource Not Starting)



  I have 4 node Cluster (3 Active 1 passive) my second node SQL Cluster resource is not starting.


i'm getting following errors. if anyone can please give me help.


Event Type:      Error

Event Source:   MSSQL$TLCSQLDBIN02

Event Category:            (3)

Event ID:          19019

The SqlAgent$wincc service is not starting


Event Type: Error
Event Source: MSSQL$WINCC
Event Category: (2)
Event ID: 17055
Date:  28/10/2010
Time:  08:59:36
User:  N/A
Computer: QC
18052 :
Error: 2775, Severity: 16, State: 1.
0000: 00004684 00000010 00000009 00430051
0010: 0057005c 004e0049 00430043 00070000
0020: 006d0000 00730061 00650074 00000072

Search Service Error 3 on starting



I am very new to Sharepoint but will do my best to help clarify and provide details you may need. We have a 3 server farm with 2 dedicated web front ends. We're running SharePoint 2007 sp2 on Server 2003 Enterprise. No Proxy Server is in use for our search. Our search began having problems a few months ago after a domain wide password change. The indexer stopped working and search would go offline intermittently. 

Not sure if this is related but we were also seeing a lot of 7078 errors in our Event Log with the description: "Job 'Distribution List Import Job' failed. It will be re-tried again in 120 second(s).  Reason: Failed to obtain crawl status."

We are able to start the Office SharePoint Server Search Service in the Services.mmc but it will not start in Central Administration. When I click on Start I get an error message each time reading:

error on attempting to start
An unhandled exception occurred in the user interface.Exception Information: Method failed with unexpected error code 3.

When I go to the 'Manage Search Service' panel in 'Application Management' there is the following info:

Under Query and Index Server it reads: "The Microsoft Search Server Service is not enabled on any server in this farm"


How to solve Application error at the time of starting debugger

Hello all,

This is my first post here. So if I posted in wrong forum point me to the correct direction.

I have installed Visual Studio 2005 (.Net 2.0) in my Windows Xp Service Pack 2 operating system.
When the setup had finished the wizard displayed me the following message :-

Visual Studio Setup is complete.
Setup is completed with some warnings."

Now when I clicked the "View Error Log" link a web document opened and there I found so many lines. Of them one is :-

"Failed to copy the file properly Webdev.Webserver.Exe"

Now when I'm trying to launch Vs2005 IDE, it is working but when I'm trying to run my programs by pressing F5 or anyone of the available debugger options I'm fetching the following errors :-

In case of windows applications (regradless whether the selected language is VB or C#) :-
"The application failed to initiliaze properly (0xc000007b). Click on OK to terminate the application."

In case of web a

Error occured while starting SQL Agent : 'Access is denied.'

Hi, I am trying to stop / start SQLAGENT service by using following syntax, EXEC xp_servicecontrol N'stop',N'SQLServerAGENT' But I am getting following erro StartService() returned error 5, 'Access is denied.' Please help me to resolve this error
Chetan SQL DBA

Error while starting OWSTimer.exe timer job



I have wierd error I try to start Windows Sharepoint Services Timer (OWSTimer.exe) from Services MMC snap-in.

Could not start the Windows SharePoint Services Timer service on Local Computer.


Error 14001: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem.


Has anyone encountered this error and can anyone suggestion solution for this error.







Intermittent SqlCeException error 25123 when starting merge replication


Hello folks!


This is a long and detailed post, I realize it is quite a mouthful but I decided that it was best to provide as much detail as possible to increase the chances of someone being able to shine some light on the subject for us.


To begin with, some background info:

·         We are building a Windows Mobile application called GuardTools Mobile to be used in the field by security guards.

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