SQLServerAgent Error: MapiLogonEx Failed due to MAPI error 273: MAPI Logon Failed (Microsoft SQL Server , Error :22022)

What steps am I missing?  I am logged on as Administrator so there should be no rights restriction.  Is there a step by step setup I can follow?
WTRogAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eugene ZCommented:
...Login to the box using the sql server agent account and then create a MAPI profile in outlook.
if it is sql server 2005
 use new SMTP  based functionality Database Mail.

http://www.mssqltips.com/tip.asp?tip=1438 
0
WTRogAuthor Commented:
I followed the Server 2005 Surface Area Configuration, so now it's just wait until tomorrow to see if we receive the e-mail alert.
0
WTRogAuthor Commented:
I checked this morning bu no e-mail alert.  I am not certain but I set this up in the Domain Administrators account do I need to be logged in as administrator or use the account we created in Exchange Server?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Eugene ZCommented:
how did you setup Database Mail and then alert?
Did you try to send test email? as per
http://www.mssqltips.com/tip.asp?tip=1438
you do not need to login as admin: but need to be sql admin admin
with Database Mail you do not need to worry about MAPI profile just make sure your port 25 is openned for SMTP server
BTW: you need to have SMTP server
try to run from sql server -ms-dos command:
telnet smtepserver 25

 
0
WTRogAuthor Commented:
Just tried to run the telnet smtpserver 25 and it failed.  We are using Exchange 2003 and under services POP3 is running, but I didn't see any options for SMTP.  I didn't see any steps in the above link on the configuration of alerts.  When I finished setting up the Database Mail the test option was grayed out.
0
Eugene ZCommented:
0
Eugene ZCommented:
btw: did you use  your  <smtpserver>?
 in the  telnet smtpserver 25
0
WTRogAuthor Commented:
220 ************Microsoft ESMTP MAIL Service, Version: 6.0.3790.1830 ready at  Wed, 29 Oct 2008 16:20:44 -0400

So, I can telnet to it.  Does IIS need to be installed on the SQL Server?
0
WTRogAuthor Commented:
I will run the SMTP install, but have to coordinate it with the staff using the program so it may be a couple of days before I can move forward with this.
0
WTRogAuthor Commented:
I was able to get SMTP installed today is there any other settings I should be aware of?
0
WTRogAuthor Commented:
I did not receive an e-mail alert this morning so I am not certain what is at the core of this issue
0
WTRogAuthor Commented:
I re-checked the settings and everything looks correct but it still fails to send e-mail alerts
0
WTRogAuthor Commented:
I think I may have found what is stopping the e-mail being sent.  I viewed Database log and seen these log messages:  
Log ID 42 DatabaseMail process is started

Log ID 43 The mail could not be sent to the recipient because of mail server failure.  (Sending Mail using account 1 (2008-11-05T05: 10:09).  Exception message:  Cannot send mails to the mail server. (Server does not support secure connections).

I went back into the Database Mail and selected Configure Database Mail and chose the Manage Database Mail Accounts and Profiles.  I chose view, change or delete an existing account and in this configuration under the Outgoing Mail Server SMTP I un-checked "This server requires a secure conneciton (SSL).

I will see if this resolves the issue.
               
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eugene ZCommented:
sorry for delay..
you need to review your DB mail setup  --> did you have SMTP server - it is not the best to install IIS-SMTP on same box with SQL SERVER...
However, it is up to you
---
---
How to Configure the IIS SMTP Service to Relay SMTP Mail  
http://support.microsoft.com/kb/230235 
 ------------
check how-to setup db mail: (just do not put reply email unless you need and email is real)
 http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22683526.html
http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx 
http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005.aspx
http://www.kodyaz.com/articles/sql2005-database-mail.aspx 
http://www.databasejournal.com/features/mssql/article.php/3626056
 
 
0
Eugene ZCommented:
good job
However,if you would check the link /  http://www.mssqltips.com/tip.asp?tip=1438  / there is unchecked "This server requires a secure conneciton (SSL)"

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.