We are implementing Artifax at our site, and so far we are trying to simplify things by keeping our reporting on the Tessitura side as much as possible. Most issues have been resolved, but one stumbling block remains: if I create an impresario View that looks at the Artifax staffskills, for example, and try to use that view to create a parameter prompt in the Report Setup System, I get this error when I try to run the report:
Select Error: SQLSTATE = 08004
Microsoft OLE DB Provider for SQL Server
The server principal "[username]" is not able to access the database "Artifax" under the current security context.
I can avoid this error in the stored procedure for the body of the report via an "execute as", but am not sure how to proceed re: Report Setup parameters.
Suggestions appreciated! Thanks.
I would execute as dbo and make sure dbo is mapped and has permissions to the artifax database.
Do you have the artifax database on the same server as impresario or will they be accessing it via linked servers?
Naomi
Thanks for your reply!
Unknown said: I would execute as dbo and make sure dbo is mapped and has permissions to the artifax database.
Since dbo is a schema rather than a login, I'm not clear on how to map dbo to a database. Can you clarify?
Same system.