SQLMail not able to send with Outlook

Posted on 2004-11-11
Last Modified: 2007-12-19
We are attempting to configure SQLMail to be able to notify our Database administrator of important SQL events through e-mail and net send.  We are having an issue that is preventing us from getting this configured.  We've gone over the Microsoft article about troubleshooting this and I think we have everything setup but apparently something is wrong.  We are using SQL 7 and Exchange 2000. Here is an e-mail from her about our current situation.

I’m trying to set up the email alerts when SQL has problems.  I cannot get the email to send.  I have made an account for SQL called SQLMail that is a System Admin in SQL, is how SQLserver service is started.  We use Outlook so the profile in SQL Mail configuration shows Outlook and starts and stops the Mapi service fine.  (We had tried to use SQLMail as the profile in the configuration but it would not start then, had a mapi failure (error 22030 A Mapi Error (Error number 273) occurred: MapilogonEx failed due to Mapi error 273).  So we currently have the server logged in as SQLMail (which is a domain account), SQLMail is running the SQLserver service, the SQLmail configuration is set to Outlook and the SQLserver Agent is started with SQLmail.   The Operator I have set up is SQLmail as well and I get an error [Error 22022: SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties Dialog.

I’ve tried setting myself up at the operator as well and gotten no where, I get the same error.  I’ve looked on line and as far as I can tell have incorporated everything suggested in the KB’s from Microsoft.  

Both SQL services are set to start as our SQLMail account which has domain administrator rights, Outlook is configured with a special profile for SQLMail and it can open and send messages just fine manually. The net send option under our Operators works, it is only the e-mail that is not.  Is there something that we are missing that can be causing this or other things we can check to get this up and running?  
Question by:Eagle6990
    LVL 19

    Accepted Solution

    Check these links;en-us;315886  //INF: Common SQL Mail Problems;en-us;263556 // INF: How to Configure SQL Mail;en-us;311231 // INF: Frequently Asked Questions - SQL Server - SQL Mail

    Melih SARICA

    LVL 5

    Expert Comment

    LVL 17

    Author Comment

    Sorry I'm just now getting back to this.  Been playing with it all week.  According to one of the Microsoft articles, Outlook 2002 has some increased security that could cause issue, so I uninstalled it, rebooted the server and installed Outlook 2000.  

    Following this article, here is my config:;en-us;315886

    1) Outlook 2000 installed on SQL 7 SP4
    2) Outlook is configured and works properly with my Exchange 2000 server.
    3) Configured
    4) Both SQLAgent and SQL Server are starting with our new domain account SQLMail
    5) SQLMail account has an Exchange mailbox that is configured and working properly.  the SQLMail service is running properly
    6) I can login as SQLMail and open Outlook just fine with no issues.  Mail is flowing in and out of this account
    7) AhHa!  There is where my problem for the time being was.  SQLAgent did not have the proper MAPI profile selected even though SQLMail did.  

    Now my mail is flowing.  Excellent!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now