Q

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

This Content Component encountered an error

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?
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

Dig deeper on Email Protocols

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchWindowsServer

SearchEnterpriseDesktop

SearchCloudComputing

SearchSQLServer

Close