Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jj
Use xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>
Showing posts with label mapi. Show all posts
Showing posts with label mapi. Show all posts
Friday, March 9, 2012
mail without mapi
Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>
mail without mapi
Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>
Wednesday, March 7, 2012
Mail Profile: MAPI error 271: One or more receipts not found
I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,
I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,
I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
Mail Profile: MAPI error 271: One or more receipts not found
I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operato
r
to get everything working after network guys moved my MAPI account to anothe
r
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was lookin
g
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operato
r
to get everything working after network guys moved my MAPI account to anothe
r
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was lookin
g
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
Mail Profile: MAPI error 271: One or more receipts not found
I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
Subscribe to:
Posts (Atom)