Can't Send mail using MultiServer Admin

Hot Topic

Project Server 2007 OLAP cubes
Using ssis task to call a web service
regedt32.exe
Function that returns table
sql 2000 trigger that sends xml
How to use web services and interactive features
Where the Data Saved
Drawing X & Y axis line on Scatter Chart where cross at: 0
Cube deployment issue SSAS 2005
Property DefaultSchema is not available for Database [DatabaseName]

SQL Server

Alternating Row Colours
To program between the process of load of data in SSIS
High CPU utilization in SQL Server 2005 SP2 (CTP)
sql script
Error on Date Data During Insert
Want to include a field from a data set in the Header of a report
Basic questions on Service Master Key
Query performance during incremental processing
Getting Error While Closing and Reopent the Same Report.
Strange behavior of format function

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone



Answer this question

Can't Send mail using MultiServer Admin

  • Shady Brady

  • Wh1sp3r

    Hi Jason,

    Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

    Regards

    Lisa

  • NReddy

    Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!

  • Avi_B

    how do you set up the smtp on your target server I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.



  • Can't Send mail using MultiServer Admin
Answer this question