Hi All,Here is the scenario, I have two databases called AppianHLS and AppianTLS on my MSSQL server respective to two different applications HLS and TLS in Appian.
Now, the AppianHLS DB has 3 tables, let's say HLS_table1, HLS_table2, HLS_table3 and a view called HLS_view1 which joins all the 3 tables on some conditions. Also I have a table called TLS_Table1.My requirement is to create a view TLS_view1 in AppianTLS DB which gets all the columns from the view - HLS_view1 and joins with the table - TLS_table1.
I have created the view TLS, and the view is working completely fine and showing the data in the database end.
Now in the appian application TLS, I have created a cdt for the view and then a record type for this entity. While adding the data source, I have selected the entity and in the data preview, I couldn't see the data and it
is showing that - "Preview currently unavailable due to an error on the source" and when I checked the logs it is showing the exception that - " The server Principal "AppianTLS" is not able to access the
database "AppianTLS" under the current security context. "
Please help me in resolving this issue.
Thanks.
Discussion posts and replies are publicly visible
harit16 Lacks permissions to access the relevant tables in the AppianHLS and AppianTLS databases.I would suggest to check security for both application object.