|
|
|
date: Mon, 18 Jul 2005 16:12:53 -0400,
group: microsoft.public.sqlserver.setup
back
Re: SQL Mail configuration
Got the answer, had to create the mail profile using the domain admin
account not the local admin account. The SQL services started with the
domain admin account.
"Alejandro Mesa" wrote in message
news:9372B5A7-63AD-404F-BE15-E2348B0341FD@microsoft.com...
> Scott,
>
> How did you create the mail profiles for sql server and sql agent
services?
>
>
> AMB
>
> "Scott Schneider" wrote:
>
> > It isn't the Outlook client config that is giving me grief, it is in
SQL. I
> > can connect with Outlook client to our Exchange server fine from the
same
> > admin user profile and mail profile from Outlook. When I try and
configure
> > "SQL Mail Configuratiion" and use the drop down menu beside "Profile
Name"
> > it will not see any mail profiles. If I manually type SQLMail (the mail
> > profile name) and press the test button, that is when I get the error
"Error
> > 18025:xp_test_mapi_profile: failed with mail error 0x80040111".
> >
> > SQL 2000 will not see any profiles I have created. I have tried both
Outlook
> > 2000 and Outlook 2002 as clients.
> >
> >
> > "Alejandro Mesa" wrote in
message
> > news:C2D958D4-8B5E-4859-A29D-44700759F806@microsoft.com...
> > > SQL MAIL and SQL Agent Mail using POP3 and SMTP
> > >
http://www.databasejournal.com/features/mssql/article.php/10894_3345091_3
> > >
> > >
> > > AMB
> > >
> > > "Scott Schneider" wrote:
> > >
> > > > I have setup a new Windows 2003 sp1 server with SQL2000 SP4. I did a
> > > > complete backup of an existing SQL2000 SP3 server (database) on 2000
> > server
> > > > SP4 and copied it onto the new 2003 server (it is going to replace
the
> > 2000
> > > > server ). Everything seems to be OK excpet for the SQL Mail Agent. I
> > have
> > > > installed Outlook 2000 and created a profile called SQLMail, which I
can
> > > > open, send/receive messages without problem.
> > > >
> > > > My version of SQLMap70.dll is 8.00.239
> > > >
> > > > When I try and configure the SQL Mail Configuration, it shows no
> > profiles on
> > > > the drop down and I get the following error
> > > >
> > > > Error 18025:xp_test_mapi_profile: failed with mail error 0x80040111
> > > >
> > > > Help, I am, stumped!!
> > > >
> > > >
> > > >
> >
> >
> >
date: Fri, 22 Jul 2005 15:55:10 -0400
author: Scott Schneider
|
|