问题描述
解决方案
参考Management Data Warehouse Data Collection fails due to login failure
错误信息提到了可能是访问权限不足,你的SQL服务器代理的账户对MDW数据库需要有mdw_admin, mdw_reader, mdw_writer角色,对msdb有e dc_admin, dc_operator, dc_pro角色
SQL Server Agent with an account that are member of the mdw_admin, mdw_reader, mdw_writer database roles in the MDW database on the MDW server and the the dc_admin, dc_operator, dc_proxy database role in the msdb database on the MDW server
时间: 2024-11-03 23:36:16