HELP!!!! SQL SERVER AGENT 2008 R2 Won't Start HELP!!!!!

[bmann]

Hello,

My SQL SERVER AGENT 2008 R2 will not start. It was working before I installed active directory. I have the following programs installed on my server. Sharepoint 2010, Visio Services, SQl Server 2008 R2 enterprise edition. This is for your information. I am not getting any specific errors when trying to start sql server agent. I also cannot start Analysis Services. I cannot start both sql server agent or Analysis Services using sql server configuration manager. I would appreciate anyone's response. The error I get is below:



************** 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.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ControlService
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ControlService.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.1600.22 ((SQL_PreRelease).080709-1414 )
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.5420 (Win7SP1.050727-5400)
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.4000.0 ((Katmai_PCU_Main).100916-1939 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.4000.0 ((Katmai_PCU_Main).100916-1939 )
CodeBase: file:///D:/Program%20Files%20(x86)/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.VisualStudiLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudiLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudiLE.Interop.dll
----------------------------------------
SqlWorkbench.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (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.1826 (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
----------------------------------------
Microsoft.SqlServer.Management.SDK.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.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.

 

[gmmastros]

Can you start the SQL Server Management Studio?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bmann]

Hello gmmastros,

Yes I can start SQL Server Management Studio with no problems. I can do everything in SQL Server Management Studio, Except cannot start SQL Server Agent. I have changed permissions using network service, local service and still the same problem. I also noticed I cannot start analysis service either. Every other service in configuration manager works fine. I have been searching the internet and tried their suggestions, but still will not start. I would appreciate your help. Also, if you know of another forum to post this problem that would be appreciated.

Thanks

 

[gmmastros]

Can you check the error logs?

In SQL Server Management Studio:

Expand "Management"
Expand "SQL Server Logs"
Double click "Current"
Put a check mark in "SQL Server Agent".
Look for errors and post them here.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLBill]

I suggest logging onto the server, go to the list of services and find the SQL Server ones. Look to see if they are set to Disabled.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[bmann]

Hello SQLBill,

I have started SQL Server Agent through Windows services, Command line, Sql Server configuration manager and using Sql Server management Studio. None of it works. I also cannot start Analysis Services. I would appreciate your info. This is the only error generated by starting SQL Server Agent. I would appreciate anyone's help. Below are the errors I am receiving:



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.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ControlService
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ControlService.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1045 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.1600.22 ((SQL_PreRelease).080709-1414 )
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.5420 (Win7SP1.050727-5400)
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.4000.0 ((Katmai_PCU_Main).100916-1939 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.5420 (Win7SP1.050727-5400)
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.4000.0 ((Katmai_PCU_Main).100916-1939 )
CodeBase: file:///D:/Program%20Files%20(x86)/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.VisualStudiLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudiLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudiLE.Interop.dll
----------------------------------------
SqlWorkbench.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (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.1826 (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
----------------------------------------
Microsoft.SqlServer.Management.SDK.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.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.

 

[gmmastros]

did you look at the error logs like I suggested?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bmann]

Hello gmmastros,

When I try to start SQL Server Agent their is no error logs generated except the dialog box that pops up showing the error I posted before. That's it.

Here is a sql Server log, But it does show anything with SQL Server Agent. Here it is below:



2011-10-24 17:45:43.07 Server (c) 2005 Microsoft Corporation.
2011-10-24 17:45:43.07 Server All rights reserved.
2011-10-24 17:45:43.07 Server Server process ID is 2192.
2011-10-24 17:45:43.13 Server System Manufacturer: 'Gigabyte Technology Co., Ltd.', System Model: 'P31-ES3G'.
2011-10-24 17:45:43.19 Server Authentication mode is MIXED.
2011-10-24 17:45:43.24 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER2011\MSSQL\Log\ERRORLOG'.
2011-10-24 17:45:43.36 Server This instance of SQL Server last reported using a process ID of 2208 at 10/24/2011 5:41:55 PM (local) 10/25/2011 12:41:55 AM (UTC). This is an informational message only; no user action is required.
2011-10-24 17:45:43.41 Server Registry startup parameters:
-d D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER2011\MSSQL\DATA\master.mdf
-e D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER2011\MSSQL\Log\ERRORLOG
-l D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER2011\MSSQL\DATA\mastlog.ldf
2011-10-24 17:45:43.86 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-10-24 17:45:44.02 Server Detected 2 CPUs. This is an informational message; no user action is required.
2011-10-24 17:45:49.50 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2011-10-24 17:45:57.12 Server Node configuration: node 0: CPU mask: 0x0000000000000003 Active CPU mask: 0x0000000000000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-10-24 17:46:01.09 spid7s Starting up database 'master'.
2011-10-24 17:46:04.63 spid7s 36 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2011-10-24 17:46:05.82 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2011-10-24 17:46:05.82 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-10-24 17:46:06.16 spid7s Recovery completed for database master (database ID 1) in 3 second(s) (analysis 1153 ms, redo 375 ms, undo 942 ms.) This is an informational message only. No user action is required.
2011-10-24 17:46:10.52 spid7s Resource governor reconfiguration succeeded.
2011-10-24 17:46:10.63 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2011-10-24 17:46:11.15 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
<{39B75A24-0837-4CEC-AFDF-B960027AE07E}>RsFxNso initialized. InstanceId = 00000001
<{50080099-5EC4-4EAF-A2A2-63C3DA97F8EB}>FsAgent is initialized
<{09C4480B-DBA4-49B7-956F-68A8B8B2445D}>FsAgent is up and running
2011-10-24 17:46:11.80 spid7s FILESTREAM: effective level = 2, configured level = 2, file system access share name = 'MSSQLSERVER2011'.
2011-10-24 17:46:17.62 spid7s SQL Trace ID 1 was started by login "sa".
2011-10-24 17:46:18.54 spid7s Starting up database 'mssqlsystemresource'.
2011-10-24 17:46:18.81 spid7s The resource database build version is 10.00.4000. This is an informational message only. No user action is required.
2011-10-24 17:46:22.83 spid16s Starting up database 'model'.
2011-10-24 17:46:22.84 spid7s Server name is 'WIN-SE61OJ3F3KA\MSSQLSERVER2011'. This is an informational message only. No user action is required.
2011-10-24 17:46:24.75 spid16s Clearing tempdb database.
2011-10-24 17:46:28.01 Server A self-generated certificate was successfully loaded for encryption.
2011-10-24 17:46:28.12 Server Server is listening on [ 'any' <ipv6> 1433].
2011-10-24 17:46:28.12 Server Server is listening on [ 'any' <ipv4> 1433].
2011-10-24 17:46:28.12 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER2011 ].
2011-10-24 17:46:28.12 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$MSSQLSERVER2011\sql\query ].
2011-10-24 17:46:33.44 spid18s A new instance of the full-text filter daemon host process has been successfully started.
2011-10-24 17:46:34.50 spid16s Starting up database 'tempdb'.
2011-10-24 17:46:37.45 spid19s The Service Broker protocol transport is disabled or not configured.
2011-10-24 17:46:37.49 spid19s The Database Mirroring protocol transport is disabled or not configured.
2011-10-24 17:46:38.46 spid19s Service Broker manager has started.
2011-10-24 17:46:49.53 Server Server is listening on [ ::1 <ipv6> 63802].
2011-10-24 17:46:49.54 Server Server is listening on [ 127.0.0.1 <ipv4> 63802].
2011-10-24 17:46:49.54 Server Dedicated admin connection support was established for listening locally on port 63802.
2011-10-24 17:46:50.93 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/WIN-SE61OJ3F3KA.authmanninb.com:MSSQLSERVER2011 ] for the SQL Server service.
2011-10-24 17:46:50.93 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/WIN-SE61OJ3F3KA.authmanninb.com:1433 ] for the SQL Server service.
2011-10-24 17:46:50.94 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2011-10-24 17:46:51.74 Logon Error: 17187, Severity: 16, State: 1.
2011-10-24 17:46:51.74 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]
2011-10-24 17:46:51.91 spid18s Starting up database 'msdb'.
2011-10-24 17:46:51.91 spid22s Starting up database 'ReportServer$MSSQLSERVER2011'.
2011-10-24 17:46:51.91 spid23s Starting up database 'ReportServer$MSSQLSERVER2011TempDB'.
2011-10-24 17:46:51.91 spid24s Starting up database 'Northwind'.
2011-10-24 17:46:51.91 spid25s Starting up database 'pubs'.
2011-10-24 17:46:52.00 spid27s Starting up database 'AdventureWorksLT2008R2'.
2011-10-24 17:46:52.00 spid28s Starting up database 'AdventureWorks'.
2011-10-24 17:46:52.00 spid26s Starting up database 'AdventureWorksDW2008R2'.