October 6, 2009 at 10:25 am
I am creating maintenance plans on a new server. I have configured Database Mail and have received test emails form it as well as from calls from a legacy DTS task I tweaked to use Database mail. I have "Send report to an email recipient" checked with my agent operator selected in the Reporting and Logging screen of each plan.
When I run a plan, either with SQL Server agent or by just executing the plan directly, all of the steps complete fine except where it is trying to send the report. The error I receive is: "Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.Could not obtain information about Windows NT group/user 'sa', error code 0xffff0002."
Any suggestions on what this is and how to fix it?
Thanks,
Jim
February 2, 2010 at 3:04 pm
I have encountered this exact problem and have solved it.
This issue occurs if you create and edit a maintenance plan when connected as SA or any other SQL Server login.
You'll need to delete the maintenance plan, and recreate it under a domain login.
The following thread is also recommended reading - deals with the database mail profile prerequisites...
http://www.sqlservercentral.com/Forums/Topic266371-146-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply