<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Error using sp_send_dbmail
20 posts, Page 1 of 2
1
2
»»
Error using sp_send_dbmail
Rate Topic
Display Mode
Topic Options
Author
Message
Lisset
Lisset
Posted Friday, November 06, 2009 4:42 PM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 11, 2012 9:32 AM
Points: 92,
Visits: 341
Hi everybody. I have a problem I am connecting to Database with user 'rpp' and when execute this code:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Administrator',
@recipients = 'lisset.arce@ewong.com',
@file_attachments = 'D:\SQLoutput\OLD_cobranza.txt',
@subject = 'Prueba RIMAC - Detalle de Cobranza'
Show the follow error:
Servidor: mensaje 22051, nivel 16, estado 1, línea 0
The client connection security context could not be impersonated. Attaching files require an integrated client login
The user rpp have the el role DatabaseMailUserRole.
Maybe I have to activate something?
Thanks for your help
Post #815258
Paul White
Paul White
Posted Saturday, November 07, 2009 2:31 AM
SSChampion
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989,
Visits: 10,529
Lisset (11/6/2009)
Servidor: mensaje 22051, nivel 16, estado 1, línea 0
The client connection security context could not be impersonated. Attaching files require an integrated client login
The user 'rpp' is a SQL Server login.
You must use a login mapped to a Windows account - also known as an 'integrated client login'.
Sending mail requires that the server act on behalf of the login, this is only possible with a Windows login - SQL Server logins cannot take part in Windows impersonation.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #815359
Lisset
Lisset
Posted Monday, November 09, 2009 8:44 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 11, 2012 9:32 AM
Points: 92,
Visits: 341
Please can you tell me how I can mapping a SQL Server login to Windows account? because I cant change the user 'rpp' for execute the SP.
Post #815833
Peter Gadsby
Peter Gadsby
Posted Monday, November 09, 2009 8:56 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:27 AM
Points: 138,
Visits: 303
Hi,
I don't think this is the problem, as I have just run the same command in my environment....
msdb..SP_SEND_DBMAIL
@RECIPIENTS = 'XXX@XXXXXX.com',
@PROFILE_NAME ='MAIL',
@SUBJECT = 'TEST',
@BODY='TEST',
@BODY_FORMAT = 'HTML',
@file_attachments = 'C:\WWW.sql'
I used a local login and all worked fine.
Have you had a look at your mail profile and sent a test email?
Regards
Peter Gadsby
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Post #815846
Peter Gadsby
Peter Gadsby
Posted Monday, November 09, 2009 8:59 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:27 AM
Points: 138,
Visits: 303
In our mail profile we use anonymous authentication... Do you use that?
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Post #815849
Lisset
Lisset
Posted Monday, November 09, 2009 9:23 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 11, 2012 9:32 AM
Points: 92,
Visits: 341
Hi Peter:
->;Have you had a look at your mail profile and sent a test email?
Yes and was succesfull. And have anonymous authentication.
Post #815884
Peter Gadsby
Peter Gadsby
Posted Monday, November 09, 2009 9:26 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:27 AM
Points: 138,
Visits: 303
Hi Hmmmmm Did you run the test mail when logged in using your rpp account?
Also did you try running the send mail command from SSMS (also using the rpp account)?
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Post #815889
Peter Gadsby
Peter Gadsby
Posted Monday, November 09, 2009 9:30 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:27 AM
Points: 138,
Visits: 303
Also is the D: drive a mapped drive? if so try using the UNC path instead. Also have you checked that the SQL Server service login has permission to look at the directory.
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Post #815894
Lisset
Lisset
Posted Monday, November 09, 2009 2:29 PM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 11, 2012 9:32 AM
Points: 92,
Visits: 341
I has run test mail with rpp logged and this user have permissions in the drive.
Post #816138
Paul White
Paul White
Posted Monday, November 09, 2009 3:20 PM
SSChampion
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989,
Visits: 10,529
Guys,
Lisset (11/6/2009)
Servidor: mensaje 22051, nivel 16, estado 1, línea 0
The client connection security context could not be impersonated.
Attaching files requires an integrated client login.
There's a huge clue right there
Paul
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #816186
« Prev Topic
|
Next Topic »
20 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
