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?