October 20, 2012 at 9:56 am
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"
October 20, 2012 at 11:45 pm
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"
October 20, 2012 at 11:53 pm
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"
November 5, 2012 at 11:10 pm
Hi
I am also getting the same error.
MSDN sites not helping to resolve the error
Thanks and Regards
Vimal
November 6, 2012 at 12:17 am
Which edition of SQl server you are using ?
-----------------------------------------------------------------------------
संकेत कोकणे
November 6, 2012 at 12:36 am
SQL SERVER 2008 Enterprise
November 6, 2012 at 12:40 am
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)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply