newbie: setting up SQL MAIL

My system:
I have installed Sql Server 2000 on my server (MS windows server 2003
enterprise edtion)
In addition Exchange Server 2003 standard edition is installed on this
server.
Every users on my network, have an e-mail account in exchange
On the clients, every user have Outlook Express with a MAPI profile.
My problem is that when I in SqlServer properties specifies SQL Mail profile
and
push the Test-button I get this error message:
"Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
And if I just push the Ok-button in the dialoge specifying SQL Mail profile.
I get this message:
"The MAPI profile was not found on the server, Are you this is what you
want?" (yes/no-button)
The profile name i specified is used in Outllook express to send email using
MAPI...
so why do I get this error..'?. (remember I'm a newbie)
Eh, I know that running Exchange and SqlServer on the same server is not a
good thing,
slow performance..etc... I´d setup this system in the porpose of learning
about
sqlserver&exchange&win2k3server...
JeffI was sure that a MAPI-compliant client, such as Outlook, had to be
installed *on* the SQL Server machine, and that it had to use an account
that SQL Server was privy to...
I think there's a way to make it work with Outlook Express, but I'm not sure
it's supported.
Maybe some helpful links here (including the possibility of using SMTP
instead of Exchange/MAPI/SQL Mail)?
http://www.aspfaq.com/2403
"Jeff" <it_consultant1@.hotmail.com> wrote in message
news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> My system:
> I have installed Sql Server 2000 on my server (MS windows server 2003
> enterprise edtion)
> In addition Exchange Server 2003 standard edition is installed on this
> server.
> Every users on my network, have an e-mail account in exchange
> On the clients, every user have Outlook Express with a MAPI profile.
> My problem is that when I in SqlServer properties specifies SQL Mail
profile
> and
> push the Test-button I get this error message:
> "Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
> And if I just push the Ok-button in the dialoge specifying SQL Mail
profile.
> I get this message:
> "The MAPI profile was not found on the server, Are you this is what you
> want?" (yes/no-button)
> The profile name i specified is used in Outllook express to send email
using
> MAPI...
> so why do I get this error..'?. (remember I'm a newbie)
> Eh, I know that running Exchange and SqlServer on the same server is not a
> good thing,
> slow performance..etc... I´d setup this system in the porpose of learning
> about
> sqlserver&exchange&win2k3server...
> Jeff
>
>|||If you continue to have problems try smtp mail. It's much simpler and more
reliable than mapi.
http://sqldev.net/xp/xpsmtp.htm
Paul
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23XB1%23pyeDHA.1748@.TK2MSFTNGP10.phx.gbl...
> I was sure that a MAPI-compliant client, such as Outlook, had to be
> installed *on* the SQL Server machine, and that it had to use an account
> that SQL Server was privy to...
> I think there's a way to make it work with Outlook Express, but I'm not
sure
> it's supported.
> Maybe some helpful links here (including the possibility of using SMTP
> instead of Exchange/MAPI/SQL Mail)?
> http://www.aspfaq.com/2403
>
>
> "Jeff" <it_consultant1@.hotmail.com> wrote in message
> news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> > My system:
> > I have installed Sql Server 2000 on my server (MS windows server 2003
> > enterprise edtion)
> > In addition Exchange Server 2003 standard edition is installed on this
> > server.
> >
> > Every users on my network, have an e-mail account in exchange
> >
> > On the clients, every user have Outlook Express with a MAPI profile.
> >
> > My problem is that when I in SqlServer properties specifies SQL Mail
> profile
> > and
> > push the Test-button I get this error message:
> > "Error 18025: xp_test_mapi_profile : failed with mail error
0x80040111".
> >
> > And if I just push the Ok-button in the dialoge specifying SQL Mail
> profile.
> > I get this message:
> > "The MAPI profile was not found on the server, Are you this is what you
> > want?" (yes/no-button)
> >
> > The profile name i specified is used in Outllook express to send email
> using
> > MAPI...
> >
> > so why do I get this error..'?. (remember I'm a newbie)
> >
> > Eh, I know that running Exchange and SqlServer on the same server is not
a
> > good thing,
> > slow performance..etc... I´d setup this system in the porpose of
learning
> > about
> > sqlserver&exchange&win2k3server...
> >
> > Jeff
> >
> >
> >
>