Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Mon, 18 Jul 2005 16:12:53 -0400,    group: microsoft.public.sqlserver.setup        back       


SQL Mail configuration   
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: Mon, 18 Jul 2005 16:12:53 -0400   author:   Scott Schneider

RE: SQL Mail configuration   
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: Mon, 18 Jul 2005 14:34:08 -0700   author:   Alejandro Mesa

Re: SQL Mail configuration   
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: Tue, 19 Jul 2005 08:54:09 -0400   author:   Scott Schneider

Re: SQL Mail configuration   
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: Tue, 19 Jul 2005 08:05:13 -0700   author:   Alejandro Mesa

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

Re: SQL Mail configuration   
Hi,

I've also faced the same problem "Error 18025:xp_test_mapi_profile:
failed with mail error 0x80040111"

But finally I got the solution and resolved.

To resolve this problem:

1. I changed Log On information of MSSQLServer from Windows Services.

2. I also changed Log On information of SQLServerAgent from Windows
Services.

To do 1 & 2 go to Windows Services window, select MSSQLSERVER and
SQLSERVERAGENT services one by one. Select Log On tab. Select "This
Account" option button instead of "Local System Account" option button.
And put my domain user acount and password as domain\userid. Domain must
be the same to which I was logged in. And lastly restarted the services.

3. Then I configured Profile information. To do this explore Control
Panel. Click on Profile icon. Removed the added email account
information and then added it again.

4. Now open Enterprise Manager of SQL and went to Database Server
Properties window. Selected Server Setting tab. Clicked on Change button
in area SQL Main and select the profile from the combo.

5. Now I went to SQL SErver Agent's propeties window and selected the
prfile name in Mail Session area.

6. Again I restarted MSSQLSERVER, SQLSERVERAGENT, Performance Log and
Alerter services from Windows Services window.

And it worked...

This might help u...

*** Sent via Developersdex http://www.developersdex.com ***
date: Tue, 06 Dec 2005 04:47:49 -0800   author:   Vishal Singh

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us