Friday, March 23, 2012

HOW TO setup SQL MAIL

hi, I want to receive a mail when SQL Server Agent JOB fail,so I go to setup the SQL MAIL,but it skip an error "xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client." Someboby can tell me how to solve it?

thank you!

Hi,

SQL Mail needs a mapi file.

You can create this file either with Outlook or with Outlook Express.

regards matthias

|||

Thank you ! can you tell me the detailed resolvent.

|||

don't forget, if you're using SQL 2005, you should use "Database Mail" instead of "SQL Mail" which is being deprecated

http://www.microsoft.com/sql/prodinfo/features/top30features.mspx

http://www.sql-server-performance.com/da_email_functionality.asp

sql

No comments:

Post a Comment