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.
Showing posts with label certain. Show all posts
Showing posts with label certain. Show all posts
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 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]
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
> to.)
>> I need to get SQL server to receive certain mail and process it directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to test,
>> but there's none their. The server is question has a mail profile set up
> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
> lost.
>> Thanks in advance,
>> NEIL
>>
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2fwc091301%2fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Neil,
>> You need to link a MAPI profile to the SQL Server Agent service account.
>> Log
>> on to the server as the SQL Server service account, configure Outlook,
>> and
>> restart your services. You should now see the mail profile in the SQL
>> Server
>> Agent properties dialogbox.
>> Jon Jahren
>> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
>> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
>> to.)
>> I need to get SQL server to receive certain mail and process it
>> directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to
>> test,
>> but there's none their. The server is question has a mail profile set up
>> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
>> lost.
>> Thanks in advance,
>> NEIL
>>
>>
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
> to.)
>> I need to get SQL server to receive certain mail and process it directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to test,
>> but there's none their. The server is question has a mail profile set up
> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
> lost.
>> Thanks in advance,
>> NEIL
>>
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2fwc091301%2fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Neil,
>> You need to link a MAPI profile to the SQL Server Agent service account.
>> Log
>> on to the server as the SQL Server service account, configure Outlook,
>> and
>> restart your services. You should now see the mail profile in the SQL
>> Server
>> Agent properties dialogbox.
>> Jon Jahren
>> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
>> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
>> to.)
>> I need to get SQL server to receive certain mail and process it
>> directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to
>> test,
>> but there's none their. The server is question has a mail profile set up
>> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
>> lost.
>> Thanks in advance,
>> NEIL
>>
>>
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/defaul...kb;en-us;263556
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=...130
1.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/defaul...kb;en-us;263556
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=...130
1.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Monday, February 20, 2012
Mac Address
Hello,
I want to block certain mac address to access my MS-SQL server. for that what can i do. for example
I want to block the mac address [abc]. how is it possible to block the mac address [abc]Use a firewall. You can't do it from MS SQL Server|||Or from a router on the network, a sample:
To determine the corresponding IP address for this MAC address, run the following DOS networking command in a DOS window:
arp -aThis displays the IP address of all connected machines.
Match up the net_address value from the sysprocesses query (step 1) with the corresponding Physical Address in the arp -a results (step 2) to determine the IP address corresponding to the Physical Address is the IP address of the machine running the blocking process. To find the corresponding hostname of this machine, run the following DOS networking command in a DOS window:
ping -a <IPaddress>In the command above, <IPaddress> indicates the IP address identified with the arp -a command.
I want to block certain mac address to access my MS-SQL server. for that what can i do. for example
I want to block the mac address [abc]. how is it possible to block the mac address [abc]Use a firewall. You can't do it from MS SQL Server|||Or from a router on the network, a sample:
To determine the corresponding IP address for this MAC address, run the following DOS networking command in a DOS window:
arp -aThis displays the IP address of all connected machines.
Match up the net_address value from the sysprocesses query (step 1) with the corresponding Physical Address in the arp -a results (step 2) to determine the IP address corresponding to the Physical Address is the IP address of the machine running the blocking process. To find the corresponding hostname of this machine, run the following DOS networking command in a DOS window:
ping -a <IPaddress>In the command above, <IPaddress> indicates the IP address identified with the arp -a command.
Subscribe to:
Posts (Atom)