Problem solve Get help with specific problems with your technologies, process and projects.

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

Dig Deeper on Exchange Server setup and troubleshooting

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.