MS SQL Server, SL mail on 2000 failed ! Urgent help needed

SL mail on 2000 failed ! Urgent help needed

Author	Message
Ashis #1 / 7	SL mail on 2000 failed ! Urgent help needed We are trying to setup SQL Mail on Win2k Adv Server with SQL 2k +SP2 . We are able to use outlook2002 sucessfully and even are able to create a profile . But when I try it in SQLmail (Enterprise Manager) it errors out as follows Error 18025: xp_testmapi_profile: failed with mail error 0x80040111 Please help Thanks All
Tue, 29 Mar 2005 00:24:58 GMT

Cory #2 / 7	SL mail on 2000 failed ! Urgent help needed Check to see if the profile you made matches the account that SQL is running under. The SQL account has to have permissions to the mailbox that the profile is created for. Quote: >-----Original Message----- >We are trying to setup SQL Mail on Win2k Adv Server with >SQL 2k +SP2 . We are able to use outlook2002 sucessfully >and even are able to create a profile . But when I try it >in SQLmail (Enterprise Manager) it errors out as follows >Error 18025: xp_testmapi_profile: failed with mail error >0x80040111 >Please help >Thanks All >.
Tue, 29 Mar 2005 00:42:55 GMT

Dinesh.T.K #3 / 7	SL mail on 2000 failed ! Urgent help needed Ashish, Refer this SQL mail FAQ... Q:Why am I getting mail error 0x80040111 (or similar hex number) when I try to send mail? A:The first step in resolving this problem is determining the error message associated with the hex error number. MAPI does not support error number to string conversion, so SQL Mail only returns the error number due to localization issues. For additional information on the MAPI error return codes, click the article number below to view the article in the Microsoft Knowledge Base: 1) Q238119 INFO: List of Extended MAPI Numeric Result Codes http://support.microsoft.com/support/kb/articles/Q238/1/19.ASP When you look up the hex value 0x80040111, you see that this corresponds to the MAPI error message MAPI_E_LOGON_FAILED, indicating that SQL Mail failed to logon with the mail profile provided. 0x80040111 corresponds to the MAPI error message MAPI_E_LOGON_FAILED. This indicates that SQL Mail failed to logon with the mail profile provided. SQL Mail failed to login to your mail server (Exchange? POP3/SMTP?) using the profile information you provided. Try the following : - Delete the SQL MAIL Profile - Reboot the server - Logon back with the account that SQL Server runs under. - Recreate the SQL MAIL Profile - Configure SQL Mail to use the profile name - Start SQL Mail. - Test SQL Mail by opening a query window and use xp_sendmail to send e-mail to yourself. Additional Information : ----------------------- 1) Q238119 INFO: List of Extended MAPI Numeric Result Codes http://support.microsoft.com/support/kb/articles/Q238/1/19.ASP 2) Q263556 INF: How to Configure SQL Mail http://support.microsoft.com/support/kb/articles/Q263/5/56.ASP Dinesh, SQL Server MVP -- -- SQL Server FAQ at http://www.tkdinesh.com Quote: > We are trying to setup SQL Mail on Win2k Adv Server with > SQL 2k +SP2 . We are able to use outlook2002 sucessfully > and even are able to create a profile . But when I try it > in SQLmail (Enterprise Manager) it errors out as follows > Error 18025: xp_testmapi_profile: failed with mail error > 0x80040111 > Please help > Thanks All
Tue, 29 Mar 2005 00:43:53 GMT

Ashis #4 / 7	SL mail on 2000 failed ! Urgent help needed Thanks Guys ! It works now but with another issue . After sending first message it hangs . I am using lotus notes 5 with Outlook client 2002 Any other tips .. Thanks Quote: >-----Original Message----- >Ashish, >Refer this SQL mail FAQ... >Q:Why am I getting mail error 0x80040111 (or similar hex number) when I >try to send mail? >A:The first step in resolving this problem is determining the error message > associated with the hex error number. MAPI does not support error number Quote: > to string conversion, so SQL Mail only returns the error number due to > localization issues. For additional information on the MAPI error return > codes, click the article number below to view the article in the >Microsoft Knowledge Base: > 1) Q238119 INFO: List of Extended MAPI Numeric Result Codes http://support.microsoft.com/support/kb/articles/Q238/1/19. ASP Quote: > When you look up the hex value 0x80040111, you see that this corresponds Quote: >to the MAPI error message MAPI_E_LOGON_FAILED, indicating that SQL Mail Quote: >failed to logon with the mail profile provided. >0x80040111 corresponds to the MAPI error message MAPI_E_LOGON_FAILED. This Quote: >indicates that SQL Mail failed to logon with the mail profile provided. SQL Quote: >Mail failed >to login to your mail server (Exchange? POP3/SMTP?) using the profile >information you provided. >Try the following : >- Delete the SQL MAIL Profile >- Reboot the server >- Logon back with the account that SQL Server runs under. >- Recreate the SQL MAIL Profile >- Configure SQL Mail to use the profile name >- Start SQL Mail. >- Test SQL Mail by opening a query window and use xp_sendmail to send >e-mail to yourself. >Additional Information : >----------------------- >1) Q238119 INFO: List of Extended MAPI Numeric Result Codes >http://support.microsoft.com/support/kb/articles/Q238/1/19 .ASP >2) Q263556 INF: How to Configure SQL Mail >http://support.microsoft.com/support/kb/articles/Q263/5/56 .ASP >Dinesh, SQL Server MVP >-- >-- >SQL Server FAQ at >http://www.tkdinesh.com >> We are trying to setup SQL Mail on Win2k Adv Server with >> SQL 2k +SP2 . We are able to use outlook2002 sucessfully >> and even are able to create a profile . But when I try it >> in SQLmail (Enterprise Manager) it errors out as follows >> Error 18025: xp_testmapi_profile: failed with mail error >> 0x80040111 >> Please help >> Thanks All >.
Tue, 29 Mar 2005 01:38:00 GMT

Jasper Smit #5 / 7	SL mail on 2000 failed ! Urgent help needed This is a known problem with SQL2000 SP2 http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q320407 You can get the hotfix from PSS or replace sqlmap70.dll with the one from SP1 or the original CD to resolve this HTH Jasper Smith Quote: > Ok friends ! here is the result > The mail gets sent alternate times In other words If I > send an email it works , If I send again it doesnot and > gives following error > SqlDumpExceptionHandler: Process 54 generated fatal > exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server > is terminating this process. > When I send again it works . It just doesnot work > consicutive .. very strage ..
Tue, 29 Mar 2005 05:24:57 GMT

Ashis #6 / 7	SL mail on 2000 failed ! Urgent help needed I see that both the DLL have same size and dates 5/23/01 1:36 AM .. are they really different . Can anyone provide that MAPI dll please thanks Quote: >-----Original Message----- >This is a known problem with SQL2000 SP2 >http://support.microsoft.com/default.aspx?scid=KB;EN- US;Q320407 >You can get the hotfix from PSS or replace sqlmap70.dll >with the one from SP1 or the original CD to resolve this >HTH >Jasper Smith >> Ok friends ! here is the result >> The mail gets sent alternate times In other words If I >> send an email it works , If I send again it doesnot and >> gives following error >> SqlDumpExceptionHandler: Process 54 generated fatal >> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server >> is terminating this process. >> When I send again it works . It just doesnot work >> consicutive .. very strage .. >.
Tue, 29 Mar 2005 21:57:41 GMT

Fargham Butt [M #7 / 7	SL mail on 2000 failed ! Urgent help needed Hi Cory, Also please make sure that the profile name is not longer than 32 characters. Please take a look at Q263556 INF: How to Configure SQL Mail and make sure that SQL Mail has been configured properly. Here are couple of other articles related to SQL Mail that might interest you: Q315886 INF: Common SQL Mail Problems Q311231 INF: Frequently Asked Questions - SQL Server - SQL Mail Q281293 SQL Mail 2000 Needs Microsoft Outlook 2000 Client Thanks, Fargham {filter} MS - SQL Server Support This posting is provided "AS IS" with no warranties, and confers no rights.
Sat, 02 Apr 2005 23:43:06 GMT

Page 1 of 1

[ 7 post ]