February 18, 2020 at 3:24 am
Hi All,
Our data collection has been enabled for a while but when I tried to view the query statistic / server statistic,
an error came out saying "Failed to connect to server , Login failed for user xxx"
I checked into this user and no permission or mapping with MDW database so I created the mapping and Grant MDW reader but still no luck
Any feedback is much appreciated
Thank you
February 19, 2020 at 4:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 19, 2020 at 10:14 am
Have a look at the errorlog of the server that your data collection is failing to connect to. That will give you the precise reason for login failure. That information is not exposed to the caller for security reasons.
John
February 21, 2020 at 12:34 am
Thanks John ..Will try
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply