SQL Server Agent service failed to start, windows 7

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Server Agent service failed to start,...

SQL Server Agent service failed to start, windows 7

Rate Topic

Display Mode

Topic Options

Author

Message

- Win

Posted Saturday, October 20, 2012 9:56 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:35 PM
Points: 86, Visits: 321

Hello,

Please help me to fix the issue. Log file pasted below.

2012-10-20 20:46:17 - ? [100] Microsoft SQLServerAgent version 10.0.1442.32 (x86 unicode retail build) : Process ID 1300
2012-10-20 20:46:17 - ? [101] SQL Server WINDOWS7ULTIMAT\BLACKDOG version 10.00.1442 (0 connection limit)
2012-10-20 20:46:17 - ? [102] SQL Server ODBC driver version 10.00.1442
2012-10-20 20:46:17 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is WINDOWS7ULTIMAT\BLACKDOG
2012-10-20 20:46:17 - ? [310] 2 processor(s) and 3033 MB RAM detected
2012-10-20 20:46:17 - ? [339] Local computer is WINDOWS7ULTIMAT running Windows NT 6.1 (7600)
2012-10-20 20:46:17 - ? [432] There are 12 subsystems in the subsystems cache
2012-10-20 20:46:17 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2012-10-20 20:46:17 - ? [129] SQLAgent$BLACKDOG starting under Windows NT service control
2012-10-20 20:46:18 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]
2012-10-20 20:46:18 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2012-10-20 20:46:19 - ? [098] SQLServerAgent terminated (normally)

Cheers,
- Win
"Dont Judge a Book by its Cover"

Post #1375109

- Win

Posted Saturday, October 20, 2012 11:45 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:35 PM
Points: 86, Visits: 321

My instances are running under LocalSystem service.
I installed 2nd instance also, same error.

I checked instance properties, permissions from management studio.
I found - "could not obtain inofrmation about Windows NT group/user 'NT SERVICE\SQLAgent$BLACKDOG', error code 0xffff0001"

I dont find correct reason and resolution for this.

Cheers,
- Win
"Dont Judge a Book by its Cover"

Post #1375144

- Win

Posted Saturday, October 20, 2012 11:53 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:35 PM
Points: 86, Visits: 321

I tried starting SQL Server Agent through Management Studio. I got below exception.
Did anyone faced the problem.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.

Server stack trace:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.FindObjectExplorerFrame()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceActionHandler.EndInvoke(IAsyncResult result)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceControlProgress.ActionCompletedHandler(IAsyncResult result)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4963 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ControlService
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1442.032 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ControlService.exe
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4968 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4961 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.SString
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SString/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
ObjectExplorer
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4971 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6071
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
----------------------------------------
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
SqlWorkbench.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
----------------------------------------
Microsoft.SqlServer.Management.SDK.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
----------------------------------------
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1816 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1816 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Cheers,
- Win
"Dont Judge a Book by its Cover"

Post #1375145

vsagg85

Posted Monday, November 05, 2012 11:10 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:13 AM
Points: 25, Visits: 27

Hi

I am also getting the same error.

MSDN sites not helping to resolve the error

Thanks and Regards
Vimal

Post #1381384

sanket kokane

Posted Tuesday, November 06, 2012 12:17 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:12 PM
Points: 323, Visits: 973

Which edition of SQl server you are using ?

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1381411

vsagg85

Posted Tuesday, November 06, 2012 12:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:13 AM
Points: 25, Visits: 27

SQL SERVER 2008 Enterprise

Post #1381416

vsagg85

Posted Tuesday, November 06, 2012 12:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:13 AM
Points: 25, Visits: 27

Output of SQL AGENT

2012-11-06 13:11:05 - ? [100] Microsoft SQLServerAgent version 10.0.1442.32 (x86 unicode retail build) : Process ID 4688
2012-11-06 13:11:05 - ? [101] SQL Server PC1-PC\PC1SQLSERVER version 10.00.1442 (0 connection limit)
2012-11-06 13:11:05 - ? [102] SQL Server ODBC driver version 10.00.1442
2012-11-06 13:11:05 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is PC1-PC\PC1SQLSERVER
2012-11-06 13:11:05 - ? [310] 2 processor(s) and 3071 MB RAM detected
2012-11-06 13:11:05 - ? [339] Local computer is PC1-PC running Windows NT 6.1 (7600)
2012-11-06 13:11:05 - ? [432] There are 12 subsystems in the subsystems cache
2012-11-06 13:11:05 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2012-11-06 13:11:05 - ? [129] SQLAgent$PC1SQLSERVER starting under Windows NT service control
2012-11-06 13:11:05 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]
2012-11-06 13:11:05 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2012-11-06 13:11:06 - ? [098] SQLServerAgent terminated (normally)

Post #1381419

« Prev Topic | Next Topic »

Permissions