Solved

Event 0,DataCollectorsvc

Posted on 2014-02-03
2
686 Views
Last Modified: 2014-02-08
Hi guys

Environment : SBS2011 Std Edition
Migrated : Yes, several months ago
MSUpdates : Fully updated, until now

The problems that i am having are listed below :

Event 0, DatacollectorSvc occurs in the event logs and that Windows SBS Manager service doesn't start, please see 1.PNG:

I recently updated the server with one update which was KB2862330 and after deploying that update the below started happening.

I've tried uninstalling the update and restarted the server but nothing has changed since.

I'm not sure if the update has caused this but would like your input on how to resolve.
The service that Windows SBS Manager is dependant on - SQL Server (SBSMonitoring) is started however event 103 SQLAgent$SBSMonitoring also doesn't start, please see 2.png.

Event 0, DatacollectorSvc

Service cannot be started. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at System.DirectoryServices.ResultPropertyValueCollection.get_Item(Int32 index)
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.ADUtil.GetUsers(String query)
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.ReportConfiguration.UpdateDomainEmailAddresses(String domainEmailAddressesXML)
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.MonitoringSQLDataStore.GetOneReportConfiguration(SqlConnection conn, SqlDataReader reader)
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.MonitoringSQLDataStore.GetReportConfigurations()
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.DataCollectorSvc.InitializeReportGenerationTask()
   at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.DataCollectorSvc.InitializeTaskList()

Thank you.
1.PNG
2.PNG
0
Comment
Question by:aNaLyz3R
2 Comments
 
LVL 7

Expert Comment

by:Lee Ingalls
ID: 39832361
I've had instances of SQL Server Agent failing to start... view your SQLAGENT.out with Notepad to see what's causing the failure.

Reference this article first:
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/30/sql-server-agent-cannot-start-because-the-instance-of-the-server-instance-is-not-the-expected-instance.aspx

Then look at this Microsoft KB article specific to 2008 but very similar to what you're experiencing:
http://support.microsoft.com/kb/955763
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 39834628
Probably easiest to just repair/reinstall SBS Monitoring:
http://technet.microsoft.com/en-us/library/gg680308.aspx

Jeff
0

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now