Ask the Expert

What do I need to install on my SQL server in order to use SQL mail?

As the new DBA in our shop, I want to use the MS-SQL mail functionality of our mixed SQL7 and SQL2K environment. We are also running a mix of NT4 and Win2K servers, still under a NT40 PDC, but hopefully moving to Active Directory real soon now.

When I asked the network administrators to set up the MAPI profile on the first server on the list to get both SQL Mail and SQL Agent Mail running, there was no mail client software on the server. What do I need to have the network admin guys do so that I can have my SQL Mail?

    Requires Free Membership to View

    Login

You've sort of answered your own question in your question. You need to install a MAPI client on your SQL server in order to use SQL Mail. There are a variety of clients out there, but if you can get a hold of the Exchange 5.0 client, that would be the preferred one. It's lightweight and easy to install. If you can't locate that, any version of Outlook will serve this purpose.

Once you have installed the MAPI client, you'll need to run SQL under an account that has a mailbox on your Exchange server. You'll also need to be logged on as this account when configuring the MAPI profile so that the profile will be available to the SQL service account.

For details on configuring SQL Mail, see http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechn ol/sql/tips/70mail.asp. See also, http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165760 and http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556. Hope this helps.

This was first published in January 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top