Forum Discussion

ChrisOnesBroken's avatar
ChrisOnesBroken
Icon for Helper I rankHelper I
9 years ago

On-Premises data gateway - the remote certificate is invalid according to the validation procedure

I've been having problems configuring On-Premises data gateway.  The problems seem to be around certificates.  When I first tried installing from the package which retrieves installation files from a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ChrisOnesBroken,

There are some proposals for you troubleshooting this issue.

1. Ensure that you download the latest version of Power BI Gateway from this link.
2. Make sure  that you add required ports and whitelist the IP addresses described in this article in your firewall.
3. Uninstall the current gateway, restart your machine, then install gateway and check if it is successful.

Thanks,
Lydia Zhang

  • ChrisOnesBroken's avatar
    ChrisOnesBroken
    Icon for Helper I rankHelper I
    9 years ago

    Lydia (@v-yuezhe-msft),

     

    Thanks for your reply.  I've ensured that I have the latest versions of Power BI Gateway.  As I said in my original post, the 556KB installer didn't even install the gateway, so I had to find the 30MB 'offline' download.

     

    The required ports and IP addresses were configured on our firewall by our networking team according to the article you reference.

     

    I've installed and uninstalled the gateway, with reboots inbetweem several times.

    • ChrisOnesBroken's avatar
      ChrisOnesBroken
      Icon for Helper I rankHelper I
      9 years ago

      I've found the trace log files from;

       

      C:\Users\[USERNAME]\AppData\Local\Microsoft\On-premises data gateway\

       

      ...and the contents are as follows;

       

      Starting trace on 14/03/2017 11:39:31 UTC
      Version: 13.0.1700.1099


      EnterpriseGatewayConfigurator.exe Information: 0 : Initialize MainViewModel
      EnterpriseGatewayConfigurator.exe Information: 0 : GetConfiguratorStateAsync
      EnterpriseGatewayConfigurator.exe Information: 0 : Configuration client returned null
      EnterpriseGatewayConfigurator.exe Information: 0 : Sign In
      EnterpriseGatewayConfigurator.exe Error: 0 : Exception: Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.EmailDiscoveryServiceException: Network request returned unexpected error. ---> System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.
         at System.Net.TlsStream.EndWrite(IAsyncResult asyncResult)
         at System.Net.ConnectStream.WriteHeadersCallback(IAsyncResult ar)
         --- End of inner exception stack trace ---
         at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context)
         at System.Net.Http.HttpClientHandler.GetRequestStreamCallback(IAsyncResult ar)
         --- End of inner exception stack trace ---
         at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.ConfiguratorClientExtensions.<DiscoverEmailProperties>d__19.MoveNext()
         --- End of inner exception stack trace ---
         at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
         at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardSignInViewModel.DiscoverCloudServiceDetails(HttpClient httpClient, String emailAddress)
         --- End of inner exception stack trace ---
         at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardSignInViewModel.DiscoverCloudServiceDetails(HttpClient httpClient, String emailAddress)
         at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardSignInViewModel.DoNext(Object param)
         at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardViewModelBase.DoNextWorker(Object param)
         at Microsoft.PowerBI.DataMovement.GatewayUXCommon.RelayCommand.<>c__DisplayClass6.<Execute>b__4()

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi ChrisOnesBroken,

        The issue is related to certificate.  You can use Fiddler to capture request URL during the installation process, then check the certificate of the URL in IE,  for more details, you can following the instructions in this similar blog.

        Thanks,
        Lydia Zhang