Problem: Sending SQL mail from SQL Server 2000 and outlook 2003

Hi there.
In our server, the following has been set up.
- SMTP server using IIS.
- SQL Server 2000 SP4
- Outlook 2003
My goal is to send SQLMAil with the above configuration. I have
followed this article to set up the MAPI profile.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
I've made sure that I used the SQL-Server service account to set up the
MAPI profile. I can send email through the outlook 2003 via this MAPI
profile without any problem.
According to the following article, I need to run keep outlook 2003
runing at the server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
This is the point that I don't understand. If I have SQL Server 2000
service running, I can't start Outlook 2003 because it complains
"Unable to open your default e-amil folders. The file
"[path-to-my-pst-file]" is in use and could not be accessed". In order
for me to start outlook 2003, I have to stop SQL Server service first.
After I start Outlook 2003, I can then restart SQL Server service
again. That's fine. The problem occurs when I run xp_sendmail to send
an email. It returns the following message.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
On the other hand, if I run SQL Server 2000 service without outlook
2003 running, I can use xp_sendmail to send email without the above
error message. It returns "Mail sent". The problem is that the email
never arrives.
Do you have any idea how I can solve this problem?
Thanks
DominicHi
If possible I would try and install an Outlook 2000 client or use XP_SMTP
http://www.sqldev.net/xp/xpsmtp.htm.
John
"domtam@.hotmail.com" wrote:
> Hi there.
> In our server, the following has been set up.
> - SMTP server using IIS.
> - SQL Server 2000 SP4
> - Outlook 2003
> My goal is to send SQLMAil with the above configuration. I have
> followed this article to set up the MAPI profile.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech
> I've made sure that I used the SQL-Server service account to set up the
> MAPI profile. I can send email through the outlook 2003 via this MAPI
> profile without any problem.
> According to the following article, I need to run keep outlook 2003
> runing at the server.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
> This is the point that I don't understand. If I have SQL Server 2000
> service running, I can't start Outlook 2003 because it complains
> "Unable to open your default e-amil folders. The file
> "[path-to-my-pst-file]" is in use and could not be accessed". In order
> for me to start outlook 2003, I have to stop SQL Server service first.
> After I start Outlook 2003, I can then restart SQL Server service
> again. That's fine. The problem occurs when I run xp_sendmail to send
> an email. It returns the following message.
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x8004011d
>
> On the other hand, if I run SQL Server 2000 service without outlook
> 2003 running, I can use xp_sendmail to send email without the above
> error message. It returns "Mail sent". The problem is that the email
> never arrives.
> Do you have any idea how I can solve this problem?
> Thanks
> Dominic
>|||I am using Outlook 2000, so I don't know if this helps.
Usually when I get "xp_sendmail: failed with mail error 0x8004011d"
it's because the pst file is locked by Outlook.
To make changes to the outlook configuration, I stop SQL Server, Open
Outlook and make the changes in there. Afterwards, I close outlook and
open restart SQLServer. If I forget to close outlook, I get this error.|||Thanks. After "downgrading" to outlook 2000, it works as expected.