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.Manag ement.Coll ector)
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.Conne ctionInfo)
-------------------------- ----
Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_coll ection_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.Manag ement.Coll ector)
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.Conne ctionInfo)
-------------------------- ----
Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_coll ection_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
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.Manag
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.Conne
--------------------------
Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_coll
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.Manag
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.Conne
--------------------------
Caught error#: 14688, Level: 16, State: 1, in Procedure: sp_syscollector_start_coll
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER