mail configuration

[alex]

Hi,

I have 4 sqlservers(sp3) with same
hardware and software running on
win2000

all servers use same domain account
(myCompany\svcsql) used by sql
service and same mail profile and mail box(svcsql)

One server send more mail then another
and this server 1-2 times a week
fails to execute sp_sendmail.

Each time we have to restart sql
service to resolve the problem.

1.If 4 servers send mail at the same time ,could one of the server "timeout" to exchange connection and cause mail failure ?

2. Should each server have
sepate mail profile and mail box ?

Thank you
Alex

[Rawhide]

1. Not likely. If it did, it wouldn't be a result of them using the same account. It would likely be the result of either network problems or Exchange server problems.

2. No need to do that.

[skhanal]

SQL Mail is very flaky and sometimes if it stops working only way to bring it back is by restarting the sql server.