Open Forum

Application server - SQL Server message 916

  • 1.  Application server - SQL Server message 916

    BRONZE CONTRIBUTOR
    Posted Dec 15, 2018 05:49 PM
    Good Day,

    Set up application server in DSL 2015. Works fine as administrator. When set up with user with minimum rights as suggested by the user guide (Application Server (96.010.00) and Application Server Administration (96.080.00) screens) I received a sql server message 916 - can't access the system db. What other rights should the application server user have? Currently, trying quick send on AR invoices but suspect this would occur with any report. I have run db maintenance, same result.

    Thanks
    Renee

    ------------------------------
    Renee Mains
    ------------------------------


  • 2.  RE: Application server - SQL Server message 916

    Posted Dec 17, 2018 05:01 PM
    Might not be your access rights.  I am finding that the stored procedure EDDNoteBodyText needs to have the following added to the beginning of the proc in order to execute on my SL 2015 installations:

    WITH EXECUTE AS'07718158D19D4f5f9D23B55DBF5DF1'

    ------------------------------
    Mark Ehleben
    President
    QBI Consulting, LLC
    Warminster PA
    ------------------------------



  • 3.  RE: Application server - SQL Server message 916

    BRONZE CONTRIBUTOR
    Posted Dec 18, 2018 05:26 PM
    Mark, Thank you!
    That did the trick.

    ------------------------------
    Renee Mains
    ------------------------------