Skip to main content
D
danszczepanski
May 21, 2025

Smart Integration Connector remote query failed.

  • May 21, 2025
  • 1 reply
  • 0 views

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?

1 reply

T
tschilling
May 21, 2025

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

Terms & ConditionsAccessibility statement