Re: SQL Mail

Do you need to use SQL Mail or will an alternative work for you?

The alternative is XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm

If you need SQL Mail, you need to log in to the SQL Server box as the
Windows user that the SQL Server services are running under. You need to
set up the mail profile as that user in order for SQL Server to be able to
see the profile.

--
Keith Kratochvil


"20302807" <20302807.27bu20@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20302807.27bu20@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi

i'm running sql 2000 and when i'm trying to start the sql Mail its
gives me this error xp_test_mapi_profile: Either there is no default
mail client or current mail client cannot fullfill the messaging
request.Please run microsoft outlook and set it as a default mail
client.

i loaded the outlook and set it as default but still its gives me the
same error i dont know what to do now, i searched on the internet for
the error number 18030 but i didnt found any solutions. Any help will
be much appreciated

thanks
Sandile


--
20302807
------------------------------------------------------------------------
20302807's Profile: http://www.dbtalk.net/m293
View this thread: http://www.dbtalk.net/t304525



.

Relevant Pages

  • Re: SQL Mail
    ... Have done all that and still no profile shows up. ... agent and sql all use the same account. ... either there is no default mail client or the current mail client cannot ...
    (microsoft.public.sqlserver.tools)
  • 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: OO vs. RDB challenge
    ... > The user profile determines the distribution of the probabilities over ... > After 1000 cycles a user task ends and so the user reaches Nirvana. ... > Show me SQL code, ...
    (comp.object)
  • Re: SQL Mail
    ... I'm having the same problem with sending mails from SQL. ... I've installed Outlook 2003, I'm logged on as the user for which the mailbox ... I've also went to SQL mail and set up a mail profile. ... "Troubleshooting SQL Mail with Exchange Server" ...
    (microsoft.public.sqlserver.server)
  • Re: My own security subsystem
    ... record your own permissions system - is this what you mean? ... system tables and was concerned that they might vary between versions of SQL ... Users have a profile with their account. ... >>> A user has an ACTUAL SQL login, instead of the generic login looking ...
    (microsoft.public.sqlserver.security)
Loading