Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL 2015 CU1 Applicatio...
Microsoft Dynamics SL (Archived)

SL 2015 CU1 Application Server for Quick Send errors with SQL Message 916

(0) ShareShare
ReportReport
Posted on by Laura 450

Testing out Application Server to use for Quick Send PO's.

Application Server user gets a SQL Server Message 916 when it is trying to send the email.

The SQL Server Message 91 states that the server principal 'xx\xx' is not able to access the system database under the current security context.

I ran synchronize ownership and it did not help; I changed the SQL user to be a sysadmin and that did not work; I removed the SQL user from the application and system databases and added it back with no change in the error message.

I made sure the SL user had rights to Application Server before creating the Application Server associated with his user.  Does the user need rights to Quick Send screens in order to process?

Could this be related to a network rights issue? I wouldn't think so since it's the SQL Server message specific to the user and system database.

Any assistance would be appreciated. 

Laura Vogel

*This post is locked for comments

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL 2015 CU1 Application Server for Quick Send errors with SQL Message 916

    Laura -

    Thank you for posting your question to the forum. I would look at the permissions of your Application Server user in SL and possibly the SL permissions of the user submitting the request. To help narrow this down, can you let us know the following:

        - Does this happen on all requests submitted to AS and emailed, or only for a specific user?

        - Has this ever worked, or are you just setting AS up new at this site?

    I agree that this does not seem like a network issue. But I know in the AS log it should show if the report was run successfully, then when the email is called and sent. Leading up to the SQL error do you see anything else that could help point to the issue?

    If the user the error is referencing the AS user, if you add that user to the Administrator group in SL does it work? If you try this, be sure to stop AS, close the SL client this user is logged into. Open SL as the SYSADMIN user and bump up his rights in SL, then have the AS user log back into SL and run AS.

    The only other option would be to run a SQL trace to see exactly at what line the SQL 91 error is being returned against.

    Hope this helps.

    Carolyn

    MSDSL Technical Support

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 CU1 Application Server for Quick Send errors with SQL Message 916

    Just curious if you ever got this resolved.  If so, what was the resolution?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans