Did you assign a domain login to the SQL Server service
statup account (& SQL Agent)? Then did you create the MAPI
profile while logged onto the server console using this
domain account? This account must also have an Exchange
mail box or have permissions to use a mail box.
> I got a trouble problem about the SQM Mail function. I
>setup the MAPI profile in WINNT4.0 already. And I can
>and received mail thought MS Outlook 2000 already.
>However, when I use SQL Mail. The Query Analyzer
>display "Mail sent" but the recipients CAN NOT received
>any mail from the system. Does anyone know why? Please
>refer to the attachment for further information, thnaks.
>P.S I am using SQL7 and installed SP3 already.