Hi,
SQL Server + Alwayson + Replication , when distributor database is on separated instance.
when I log into the server with the administrator user, on Replication Monitor, selected a publication and right click in subscription + "view Details", view details appear normally.
But, when connect on instance remotely, or remote desktop on server, but with non-Administrator user, "view details" gives the error:
TITLE: Replication Monitor
Replication Monitor could not open the Detail Window.
ADDITIONAL INFORMATION:
The start context provided for this Detail Window is incomplete. The following input is missing: DistributorConnInfo (ReplicationMonitor)
The users I'm connecting to SQL Server are sysadmin. I've also tried adding the "replmonitor" role on distributor database, but it still gives an error.
Can help find what's missing to make it work?
Thanks
Doug