Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor III
31 days ago

Smart Integration Connector remote query failed.

I am trying to query the data from the client source database through a Data Adapter, but it is returning this error:

Is this an issue with our setup on the OneStream end or something with the database configuration on the client side?

Data Integration

1 Reply

  • tschilling's avatar
    tschilling
    New Contributor III
    31 days ago

    Hard to tell from the error, but is the EpicorERP DB running on SQL or Azure SQL?  Looks to be a permissions issue with that Service Principal.  One suggestion would be to have the person who set that account up, prove they can login with that service principal via SSMS or Azure Data Studio