We have some users that are able to log into report portal, they can connect to the cube and get the measures and dimensions. When they go to add the first measure the get an error "No connection could be made because the target machine actively refused it xxx.xxx.xxx.xxx:80". I can not reproduce this in other users. I have two users that are set up the same and one will get it and the other will not.
We have SSL forced on this website. I have opened port 80 on IIS and the firewall just to test if this would resolve this error. It did not help.
If anyone has seen this or can help I would greatly appreciate it.
Please go to Admin > Connection Select the XMLA connection used by the report Enter Windows’s User Name and password of the user that has the problem Click Test
I entered the username and password of a user with the issue and I received a Success!. I then double checked that the user was still have the issue and it is.
I fixed this Thank you for your help. In doing all of these double checks I noticed that they had access only to the test connection. when I gave them access to the production connection also they were able to work.