Open Forum

Application server - SQL Server message 916

  • 1.  Application server - SQL Server message 916

    BRONZE CONTRIBUTOR
    Posted 12-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 12-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 30 days ago
    Mark, Thank you!
    That did the trick.

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