Can't setup SQL AgentMail

Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>

---

|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> glsD
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
run[QUOTE]
>

---

Can't setup SQL AgentMail

Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>

Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ? if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!
Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:

>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ? if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ' if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:
>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ' if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

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?

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!|||

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

|||

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.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

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?

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!|||

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

|||

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.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

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?

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!|||

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

|||

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.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm