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 Email Protocols
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.