Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1420
  • Last Modified:

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
0
TickTech
Asked:
TickTech
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
Start SQL Server Agent is stopped

go to services.msc and set sql server agent to start automatically (or delayed start) it is probably disabled or manual start  right now) and click the start button servicesAgent Start Typestart agent and set to automatically startagent is now running
1
 
TickTechAuthor Commented:
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.
1

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now