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