Forum Discussion

rerangel's avatar
rerangel
Icon for Helper I rankHelper I
8 years ago

on premise gateway Invalid credentials

Hi  I have a Sql Server running ok. I have Windows Domain admin credentials.  I installed the gateway in a VM with windows server 64 bits succesfully. I have Power bi Pro licence and i am the admi...
deldersveld's avatar
deldersveld
Icon for Resident Rockstar rankResident Rockstar
8 years ago

A client recently had this issue, and it ended up being an SSL certificate issue. The cert did not match the connection string used in the Power BI connection. Another workaround they found while not ideal would be to use a SQL login instead of Windows.

  • rerangel's avatar
    rerangel
    Icon for Helper I rankHelper I
    8 years ago

    Hi

    Thanks for your time.

    I changed the credentials in the gateway  from windows to Basic. 

    The sql user has full persmisions sysadmin.

    saddly It didnt work.  

    I am gona dig up about SSL certificate.

    Thanks  for your help. 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Hi there, does your SQL Server use Encryption?
      • rerangel's avatar
        rerangel
        Icon for Helper I rankHelper I
        8 years ago

        Hi

        The sql doesnt use Encryption

  • rerangel's avatar
    rerangel
    Icon for Helper I rankHelper I
    8 years ago

    Hi.

    I recently read about the SSL Certificate, tha is installed by de Personal Gateway.

    I unistall on premis gtw. and installed Personal Gateway. 

    Didnt work.

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      It should be working fine. Can you connect from your Gateway server to the SQL server?
      • rerangel's avatar
        rerangel
        Icon for Helper I rankHelper I
        8 years ago

        Hi GilbertQ

         

        Yes.  the computer where the gateway is installed, has Windows 2012 server 64 bits. I have Sql SSMS and connect to de database without problem.  I make querys and work fine. 

        In the domain controler is installed the Sql Server.  My windows user has Domain admin credentials. 

         

        In the Power Bi Service the gateway appears ON LINE. no errors.  I created the data Origins, to sql server, with windows credentials, get on line. Until here, everything just fine. piece of cake.

         

        Buut when i go to the data set and try to refresh or the automatic schedule try to refres, get the invalid credential error.

        I read the troubleshooting docs. 

        We dont have proxy. 

        Another says the SSL and must install personal gateway, wich i did, but same result.

         

        So, i have not solve this mistery yet.