Re: SQL Mail

Have done all that and still no profile shows up. The Server user, sql
agent and sql all use the same account. I have a third party app that
requires the agent mail to function.

Thanks
Gary
"Keith Kratochvil" <sqlguy.back2u@xxxxxxxxxxx> wrote in message
news:%231jORL$OGHA.516@xxxxxxxxxxxxxxxxxxxxxxx
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: Critical Error: Attempt to release mutex not owned by caller
    ... Run a script prior to running the backup to stop MS SQL and the Agent. ... alinkns's Profile: http://forums.techarena.in/members/alinkns.htm ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mail
    ... Do you need to use SQL Mail or will an alternative work for you? ... set up the mail profile as that user in order for SQL Server to be able to ... mail client or current mail client cannot fullfill the messaging ...
    (microsoft.public.sqlserver.tools)
  • RE: Replication Error
    ... account that the SQL Agent runs under. ... When I setup replication two jobs are setup within sql server server. ... step of each job (Snapshot Agent startup message, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Mail
    ... > I'm having the same problem with sending mails from SQL. ... I've also went to SQL mail and set up a mail profile. ... > used to start SQL Server. ... > be a domain account if you are using an Exchange server as ...
    (microsoft.public.sqlserver.server)
  • Re: permission problem?
    ... SQL Agent has an errorlog file, which you for instance can get to from EM, ... I suggest you read in Books Online about permissions. ... >> What error messages do you have in the SQL Server Agent errorlog? ...
    (microsoft.public.sqlserver.server)