Re: SQL Mail

When configuring Outlook on the box you have to log in as the user that the
SQL Server is running under. That will allow SQL Server to "see" the
profile.

An alternative to SQL Mail is sp_smtp_sendmail. You can find it here:
http://www.sqldev.net/xp/sp_smtp_sendmail.htm


--
Keith Kratochvil


"Gary Angus" <gary@xxxxxxxxxxx> wrote in message
news:e5wYkp%23OGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run.
Installed Outlook 2000 and setup my profiles as Internet POP3. I can send
mail fine from Outlook. In SQL no profiles are found. In SQLAgent the
Mail
section is greyed out. Server login, SQL service, and SQLAgent service
are
all the same user (an admin on the local machine). Get error Msq: 18030
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. I have setup Outlook as the default mail client
in Explorer. I have deleted and reinstalled profile many times and
restart
services. No luck. Any ideas?

Thanks
Gary Angus




.

Relevant Pages

  • Re: SQL Mail & Outlook 2003
    ... I downloaded and installed SQL Server 2005 Express when I decided to switch ... already has SQL Server 2000 Developer up and running with my database, ... non-profit organization...my dev box is my home PC (hence the Outlook 2003, ...
    (microsoft.public.sqlserver.setup)
  • Re: Integrating SQLServer and Exchange
    ... MAPI profile without actually needing a mail client of any sort. ... > This feature of SQL requires you install a mail client (ie outlook). ... >> When setting up SQL Server 2000 Standard or Enterprise, ...
    (microsoft.public.windows.server.sbs)
  • SQL Mail
    ... Running SQL 2000 sp4 on W2003 server. ... Installed Outlook 2000 and setup my profiles as Internet POP3. ... either there is no default mail client or the current mail client cannot ...
    (microsoft.public.sqlserver.tools)
  • Re: Application sending email
    ... Top Causes of SQL Server Downtime ... "Is it better to use a mail client that has no ... how can you secure Outlook... ... Package developers want to install Outlook on SQL server (has to ...
    (microsoft.public.sqlserver.security)
  • Re: What needs to be set up to use the xp_sendmail Stored Procedure?
    ... using this approach instead of SQL mail and MAPI. ... I installed Outlook 2000 on the SQL Server. ...
    (microsoft.public.sqlserver.setup)