xp_sendmail: Procedure expects parameter @user
-
I'm running SQL 2000 and am trying to port over my useful stored procedures from a previous job. In the past, I used xp_sendmail without any big hassle.
Here, I've already set up an Outlook 2000 mail account and logged into that server with that account name. The test command I used from master was
xp_sendmail @recipient = 'me@mycompany.com'
, @message = 'body message'
, @subject = 'sql mail test subject'
I get the error
"Server: Msg 17985, Level 16,State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied".
I tried looking through BOL and the knowledgebase (article 263556), but have had no success. Any suggestions are appreciated.
-
I've moved the question to a different forum within sqlservercentral.
Maybe the higher visibility of the question will help
-
I don't receive that error message!!! After executing the sentence below:
EXEC xp_sendmail 'xxx@yahoo.com', 'body message','sql mail test subject'
I got this different message:
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: There is not any predetermined e-mail client, or the current e-mail client can not satisfy the courier demmand. Launch Microsoft Outlook and configure it as the predetermined e-mail client.
Sorry about translation! (No hay un cliente de correo predeterminado o bien el cliente de correo actual no puede satisfacer la petición de mensajería. Ejecute Microsoft Outlook y establézcalo como cliente predeterminado.)
Hope this message can help you to find out something else...
-
Did you set up the profile in outlook(when logged in as the SQL service account), ensure it's the default profile and that outlook is the default mail client?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply