SBX - Search With Button

SBX - Forum Post Title

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

Microsoft Dynamics SL Forum

Laura asked a question on 21 Feb 2018 4:02 PM
My Badges

Question Status

Suggested Answer

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

Reply
jenni Arant responded on 9 May 2018 12:49 PM
My Badges

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

Reply
Carolyn Froton responded on 1 Jun 2018 12:23 PM
My Badges
Suggested Answer

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

Reply
Carolyn Froton responded on 1 Jun 2018 12:23 PM
My Badges
Suggested Answer

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

Reply

SBX - Two Col Forum

SBX - Migrated JS