I've written a quick report in SSRS that looks at the Transcend deposits and links them back to the Tessitura postings to make it easier for my Finance department to reconcile with the bank. The code runs fine from SSMS (on as a sa equivalent) and from inside Visual Studio. It fails with a "Query execution failed for dataset" when I run it from Tessitura.
How do I grant permissions on the TPAU tables so I can reference them from a Tessitura report?
Thanks.
-steve carlock
Hi Steve
Maybe you could go around the back of that problem by linking the servers, and building views (or whatever) in the Tess database that represent tables in the TPAU db. Then if you re-base your reports on them, that will trick Tess into thinking it's reporting from itself (hopefully - I haven't actually done that.). IN that case, the TPAU end would execute with the security context provided by the link, and the tess end would just need normal execute permissions on your proc.
Ken