Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor III
2 months 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 d...
Data Integration
tschilling's avatar
tschilling
New Contributor III
2 months 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