When trying to send e-mail out from SQL server I get the following error: Error string: Server response: 550 5.7.1 Unable to relay for email@.domain.com.
I am using XPSMTP, which sends mail without the use of a mapi client.
If I load up outlook on the server I can send mail externally? Why would the exchange server not relay mail out of the stored procedure, but do it for everything else?did you check the SMTP stuff in IIS which is required for SMTP mail to work?|||i do not have access to the IIS server, because I am a contractor at this company
the thing is, i just tested the sql server agent and it sends mail just fine to external addresses
so i know sql server can do it, but i feel like XPSMTP is limited in some way, perhaps the error message is wrong?|||well the sql server agent is likely running on a domain account with an exchange account and that is how sqlmail works.
smtpmail, as I recall (it's been over a year since I did this) requires somes setup and a running smtp service within IIS. this can be a security issue btw. I would refer to the documentation on the web page for xp_smptmail.|||yes the sql server agent is running off a domain account
i'm using XPSMTP a 3rd party .dll. it does not require IIS, in fact it doesnt really require anything
their website has that error message documented but it doesn't make sense, if i can send mail from the SQL Agent I should have no problem relaying mail from the XPSMTP80.dll
i've been trying to set up SQL mail with no success, sql server does not recognize a profile name in the drop down box in enterprise manager
i have outlook 2000 set up and configured and all...
Showing posts with label e-mail. Show all posts
Showing posts with label e-mail. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
Mail Notifications Stop Working
We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP3a) on a 4-processor Dell box.
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP3a) on a 4-processor Dell box.
Mail Notifications Stop Working
We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.
Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.
|||Not using fibers. The only messages in the agent error log are the normal informational ones that are found when restarting the agent, i.e., version, processors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:
[vbcol=seagreen]
> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
QL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't
know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.
>
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.
Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For reasons I cannot seem to find, the e-mail notifications have stopped coming (net sends do work). I can send mail from the SQL Agent service account from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.
|||Not using fibers. The only messages in the agent error log are the normal informational ones that are found when restarting the agent, i.e., version, processors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:
[vbcol=seagreen]
> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
QL won't even send me a test mail from within SQL (using Ent. Mgr). However, SQL thinks the mail was sent OK, as it says "mail successfully sent". However, the test mails never show up. Short of rebooting the server (a 24/7 production server), I don't
know where to go. Have checked the accounts, stopped and started the agent, etc. If this is a clue, the agent also won't run some scheduled jobs. One daily job actually last ran two days ago, yet I don't see any errors or messages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.
>
Mail Notifications Stop Working
We have some jobs that should e-mail the operator upon certain conditions.
For reasons I cannot seem to find, the e-mail notifications have stopped com
ing (net sends do work). I can send mail from the SQL Agent service account
from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, et
c. If this is a clue, the agent also won't run some scheduled jobs. One da
ily job actually last ran two days ago, yet I don't see any errors or messag
es. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For rea
sons I cannot seem to find, the e-mail notifications have stopped coming (net sends
do work). I can send mail from the SQL Agent service account from the desktop, but
SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, e
tc. If this is a clue, the agent also won't run some scheduled jobs. One d
aily job actually last ran two days ago, yet I don't see any errors or messa
ges. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.|||Not using fibers. The only messages in the agent error log are the normal i
nformational ones that are found when restarting the agent, i.e., version, p
rocessors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:
> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
>
QL won't even send me a test mail from within SQL (using Ent. Mgr). However,
SQL thinks the mail was sent OK, as it says "mail successfully sent". How
ever, the test mails never show up. Short of rebooting the server (a 24/7 p
roduction server), I don't
know where to go. Have checked the accounts, stopped and started the agent,
etc. If this is a clue, the agent also won't run some scheduled jobs. One
daily job actually last ran two days ago, yet I don't see any errors or mes
sages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.[vbcol=seagreen]
>
For reasons I cannot seem to find, the e-mail notifications have stopped com
ing (net sends do work). I can send mail from the SQL Agent service account
from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, et
c. If this is a clue, the agent also won't run some scheduled jobs. One da
ily job actually last ran two days ago, yet I don't see any errors or messag
es. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:
>We have some jobs that should e-mail the operator upon certain conditions. For rea
sons I cannot seem to find, the e-mail notifications have stopped coming (net sends
do work). I can send mail from the SQL Agent service account from the desktop, but
SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, e
tc. If this is a clue, the agent also won't run some scheduled jobs. One d
aily job actually last ran two days ago, yet I don't see any errors or messa
ges. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.|||Not using fibers. The only messages in the agent error log are the normal i
nformational ones that are found when restarting the agent, i.e., version, p
rocessors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:
> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
>
QL won't even send me a test mail from within SQL (using Ent. Mgr). However,
SQL thinks the mail was sent OK, as it says "mail successfully sent". How
ever, the test mails never show up. Short of rebooting the server (a 24/7 p
roduction server), I don't
know where to go. Have checked the accounts, stopped and started the agent,
etc. If this is a clue, the agent also won't run some scheduled jobs. One
daily job actually last ran two days ago, yet I don't see any errors or mes
sages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.[vbcol=seagreen]
>
Subscribe to:
Posts (Atom)