July 20, 2010 at 11:19 am
Hello -
I recently migrated from 2000 to 2005. We use XP_SENDMAIL (I know that I need to switch to db mail but have not had time to do this yet).
When adding an attachment (which worked in 2000) I get:
xp_sendmail :The client connection security context could not be impersonated. Attaching files require an integrated login
I use sql authentication. If I switch the user to have sysadmin rights, the xp_sendmail with attachment works. For obvious reasons I do not want to have to give sysadmin rights to the user that I log in with to run this procedure.
I get the same error if I am trying to run xp_sendmail with a query so I dont think it has to do with permissions on the file themselves.
Does anyone know of any work arounds for this issue???
Any thoughts, ideas, etc would be great!!
July 21, 2010 at 6:21 am
Bummer.....I was hoping people would have 'some' ideas.......
Anyone have any thoughts on using 'Control Server' for the user? Pros/cons??
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply