In Qlik Office 365 Sharepoint Connector (Qlik Web Connectors), after logging in on the Sharepoint portal, copy the Authentication Code and click save, the connector fails with the following error:
An error occurred while trying to authenticate (status code = 500, Unable to connect to the remote server, Message: Unable to connect to the remote server)
Qlik Web Connectors logs reports the following entry:
<ExceptionMessage>The operation has timed out</ExceptionMessage>
When the button "Save" is pressed, Qlik Web Connectors needs to reach https://login.microsoftonline.com and https://graph.windows.net to convert the authentication code to an authentication token. If these addresses are not reachable after some time, the connection fails with the above messages.
Resolution:
Make sure login.microsoftonline.com and graph.windows.net are reachable on port 443 from the server where Qlik Web Connectors is installed. This can be verified by doing telnet commands from the Windows command line, for example:
telnet login.microsoftonline.com 443
telnet graph.windows.net 443
If telnet is successful and the issue still persists, make sure nothing is blocking from the firewall end by checking with customer IT for the above sites.