January 29, 2003 at 2:26 pm
I'm getting the following error when executing the xp_sendmail command in a SQL 6.5 server.
Msg 17914, Level 18, State 1
Unknown recipient: Parameter '@recipients', recipient 'xyz1234@csc.com'
On other SQL 6.5 servers the command is working fine. Microsoft lists a bug under SQL 7.0 when the recipeint list is > 256 characters. This is not the problem here, as the recipient is not very large.
Has anyone seem this problem? If so, what was the resoltion?
Thanks for your help.
Winston Peters
Winston Peters
January 29, 2003 at 3:16 pm
Not sure and it's been awhile since I worked with 65. Usually this is some name resolution issue. Have you tried logging in as the SQL Service account and sending mail manually to this account. Maybe stop and restart SQL?
Reaching here.
Steve Jones
March 26, 2005 at 2:28 pm
I am also having similar problem and looking for some help. Does anyone know solution of this? I have logged into sql server with the same id and am able to send emails from outlook. Only thing is i can not send email from sql server (xp_sendmail).
March 28, 2005 at 2:23 pm
Does the service account for sql service the same as whatever the account you use to login and send email via outlook? It should be the same.
mom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply