Has anyone managed to connect a DataSource to an SQL Server schema other rthan .dbo?

Hi all

I have a cloud implementation of Appian and am trying to connect through to  a local SQL Server 2016 server. I can do this fine and connect a datastore to tables in the .dbo schema  but don't appear to be able to connect to tables in any other schema - the datastore just doesn't allow any connections to be established to anything other than .dbo. There are pieces of documentation that suggest that this should be possible and some referring to synonyms but none appear to work for me

 

Has anyone else succeeded in doing this?

 

Many thajs 

  Discussion posts and replies are publicly visible

Parents Reply Children