Forum Discussion

Do57792's avatar
Do57792
Icon for Advocate I rankAdvocate I
2 years ago
Solved

certificate chain was issued by an authority / PBI_SQL_TRUSTED_SERVERS

Hi,   In a SQL query that I have run several times before I am not receiving the following error:    Message=A connection was successfully established with the server, but then an error occurred ...
Need Help
  • Do57792's avatar
    Do57792
    2 years ago

    Case Closed. Using another connector helped to set up SQLs/connect to the database. 

    Using OLE DB was working well insted of SQL Server, which was working fine before the update.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have same issue with on premise sql server database, we put enviroment variables of sql server domain name, does not work at all

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Remember that the method differs between desktop and gateway.  On desktop it's the enviroment variable, on gateway it is a config file edit.