Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
josanand
Starting Member
1 Post |
 Posted - 2008-09-01 : 23:38:39
|
| Hi,I'm running SQL 2005 on win 2003 server and I'm processing incoming emails through SQL Mail using procedures like xp_findnextmsg, xp_readmail. All was working fine for about one month and suddenly SQL server stopped processing emails I tried restarting the SQL server then SQL Agent, Stopped the mail session using xp_stopmail but when tried to restart comes up with an error message "Msg 17930, Level 16, State 1, Line 0xp_startmail: 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. "Also when I right-click SQL Mail->properties it comes with the below error messageCannot show requested dialog.Additional information: If a stored procedure could not be found.SQL Mail may not be installed in the instance. (SqlManagerUI) 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. (Microsoft SQL Server, Error:17930)I know for sure that Outlook has been installed and configured as the default MAPI client and SQL Mail procedures were enabled as everything was working fine.Can anybody help me on this please.Regards,joseph. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-03 : 09:12:07
|
| http://sqlblogcasts.com/blogs/ssqanet/archive/2008/06/19/xp-sendmail-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.aspx |
 |
|
|
|
|
|
SQL Mail problem - xp_get_mapi_profiles