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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: