Link to home
Start Free TrialLog in
Avatar of TickTech
TickTech

asked on

Configuring SQL server 2012 Management Data Warehouse error

Management data warehouse successfully created.
Error attached below occurred when trying to configure.
The URL does not provide any useful information.

Anybody has experience with this? Thanks for your attention.

////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
- Start system collection sets (Error)
Messages
Failed to configure data collection

------------------------------
ADDITIONAL INFORMATION:

Unable to start collection set Disk Usage. (Microsoft.SqlServer.Management.Collector)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_collection_set, Line: 33, with Message: A collection set cannot start when SQL Server Agent is stopped. Start SQL Server Agent. (Microsoft SQL Server, Error: 14684)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2218&EvtSrc=MSSQLServer&EvtID=14684&LinkId=20476
 
Warning: Database created by the wizard is not cleanup after failure.

------------------------------
ADDITIONAL INFORMATION:

Unable to start collection set Disk Usage. (Microsoft.SqlServer.Management.Collector)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_collection_set, Line: 33, with Message: A collection set cannot start when SQL Server Agent is stopped. Start SQL Server Agent. (Microsoft SQL Server, Error: 14684)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2218&EvtSrc=MSSQLServer&EvtID=14684&LinkId=20476
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TickTech
TickTech

ASKER

Thank you very much for your help and explaining it even with pictures. I was able to get the error message resolved with your help.