Collection error in Spotlight: "Collection 'Database List failed: The SELECT permission was denied on the object 'log_shipping_monitor_primary', database 'xxx' schema 'dbo'." (4222513)

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

Collection error in Spotlight: "Collection 'Database List failed: The SELECT permission was denied on the object 'log_shipping_monitor_primary', database 'xxx' schema 'dbo'." (4222513)

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Collection error in Spotlight: "Collection 'Database List failed: The SELECT permission was denied on the object 'log_shipping_monitor_primary', database 'xxx' schema 'dbo'."
Descripción

The following error occurs in Databases drilldown:

"The following error occurred while collecting data, Collection 'Database List (protected)' failed: The SELECT permission was denied on the object 'log_shipping_monitor_primary', database 'xxx' schema 'dbo'."
Causa

Monitoring SQL Server instance with non-SA role account.
Resolución

SOLUTION 1:
Change account used to monitor this instance to an account having SA role in that instance.

SOLUTION 2:
As the SA user, execute the sql script below against the instance lacking permissions (replace trusteduser):

use msdb EXECUTE
sp_addrolemember
@rolename = 'TargetServersRole',
@membername = 'trusteduser'
grant select on dbo.sysalerts to trusteduser

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Solicitar un artículo KB

Contenido recomendado

Producto(s):: Spotlight on SQL Server Enterprise
12.2, 12.1, 12.0.1, 12.0

Tema(s):: Troubleshooting

Historial del artículo:: Creado el: 6/26/2017
Última actualización: 5/7/2023

Buscar todos los artículos

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Collection error in Spotlight: "Collection 'Database List failed: The SELECT permission was denied on the object 'log_shipping_monitor_primary', database 'xxx' schema 'dbo'." (4222513)

Título

Descripción

Causa

Resolución

Leave a Comment