Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 4:02 PM
Points: 12, Visits: 55
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
Actually that does make sense, whatever was trying to connect to that other database lacked sufficient rights to access the database..

CEWII
Post #1466871
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse