We help IT Professionals succeed at work.

Problem Starting Mail Session

piratepatrol
piratepatrol asked
on
Hi friends,

When I run "EXEC xp_startmail", I get the following error:

"xp_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."

But I do have Microsoft Outlook running and it is the default mail client!  What am I missing?  Please help.

Thanks, friends.


Jazon from Jacksonville, FL
Comment
Watch Question

Commented:
Check who is trying to use the mapi client.
From Books On Line, may be helps:

If mapi_profile_name and mapi_profile_password are provided, Microsoft SQL Server attempts to log on to Windows NT Mail (or other MAPI provider) using that user name and password. If mapi_profile_name and mapi_profile_password are provided but are incorrect, an error message is returned. If mapi_profile_name and mapi_profile_password are not provided, SQL Server uses the user name and password specified in the SQL Server Properties dialog box. If no user name or password is explicitly provided, SQL Server will attempt to log in to the MAPI provider using the default MAPI profile. Some MAPI providers may be configured to use Windows Authentication, in which a case, the MAPI password is ignored.
If you use xp_startmail to start your mail sessions, you can optionally supply your login name and password so that you do not have to type it at the command prompt. However, SQL Mail will not piggyback an existing client session of Windows NT Mail if one is running. This behavior differs from SQL Server version 7.0 and earlier.
If there is an existing mail session, xp_startmail does not start a new one. If mail is being used on the same computer on which SQL Server is also running, the mail client must be started either before xp_startmail is executed, or before SQL Server is started if SQL Mail is configured to automatically start when SQL Server starts.

Guy Hengel [angelIII / a3]Billing Engineer
GOLD EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
Is the SQL Server Service running under NT Account?
If not, do change this.

Then, log on to the SQL Server box using that account, and verify that you can open the Mail Client, which should also use the "default" profile. Opening the client should succeed without any message or popup (for example Auto-Archive...)

This should help.

CHeers
piratepatrol,

Some of these questions have been open for some time, and records indicate you logged in as recently as a today. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20260974 (new)
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20258569 (new)
http://www.experts-exchange.com/jsp/qShow.jsp?ta=cplusprog&qid=20174572
http://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20168259
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20159537
http://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20232167

Thanks,

Netminder
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.