Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

Database Mail failing with attachment Expand / Collapse
Posted Monday, June 24, 2013 10:57 AM


Group: General Forum Members
Last Login: Monday, February 23, 2015 2:53 PM
Points: 12, Visits: 56
Dug further and found this error:

The server principal "xxxx" is not able to access the database "yyyy" under the current security context.

Where xxxx is the SQL Server Agent account. Added that account specifically with sa privileges and fixed the problem. Weird we had to do that just for jobs that have query results as an attachment because as mentioned all others were working fine.

Thank you for your replies.
Post #1466841
Posted Monday, June 24, 2013 1:01 PM



Group: General Forum Members
Last Login: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
Actually that does make sense, whatever was trying to connect to that other database lacked sufficient rights to access the database..

Post #1466871
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse