Solved

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

Posted on 2008-10-24
15
2,027 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:WTRog
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 6
15 Comments
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22816443
...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
 

Author Comment

by:WTRog
ID: 22823201
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
 

Author Comment

by:WTRog
ID: 22831461
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 42

Expert Comment

by:Eugene Z
ID: 22831519
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
 

Author Comment

by:WTRog
ID: 22832359
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
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22833854
0
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22833858
btw: did you use  your  <smtpserver>?
 in the  telnet smtpserver 25
0
 

Author Comment

by:WTRog
ID: 22835247
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
 

Author Comment

by:WTRog
ID: 22841259
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
 

Author Comment

by:WTRog
ID: 22869429
I was able to get SMTP installed today is there any other settings I should be aware of?
0
 

Author Comment

by:WTRog
ID: 22875627
I did not receive an e-mail alert this morning so I am not certain what is at the core of this issue
0
 

Author Comment

by:WTRog
ID: 22885024
I re-checked the settings and everything looks correct but it still fails to send e-mail alerts
0
 

Accepted Solution

by:
WTRog earned 0 total points
ID: 22886922
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
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22887899
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
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22929628
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

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Merige returns error code when updating 15 57
SQL Backup skipping a few tables 7 58
Table create permissions on SQL Server 2005 9 45
Replication failure 1 19
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question