Database Mail Doesn't Work

I am having trouble getting database mail to work. I have tried many things, but can't make it work.

Initially, I setup IIS opn the same box as a virtual SMTP server. I set it up to relay to 127.0.0.1. In sql server, I setup database mail
to point to localhost, with no authentication. After the setup, when I test the email it works fine.


I created a job that will fail every time. I setup myself as the notify party on the job. When I run the job, it fails.
I get no email. The job log has the following error (notice failed to notify):

Message
The job failed. The Job was invoked by User xxxxAdministrator.
The last step to run was step 1 (test 1).
NOTE: Failed to notify 'Dan Jones' via email.

In the SQL Server log, I see:

[264] An attempt was made to send an email when no email session has been established


Also:

Message
[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
a)

This is my preferred configuration, but I couldn;t make it work, so I tried another...


I tried to setup mail through my mail service provider. I entered the IP in sql server. When I test it, I get the following error:

Date 11/19/2007 8:16:06 AM
Log Database Mail (Database Mail Log)

Log ID 24
Process ID 3176
Last Modified 11/19/2007 8:16:06 AM
Last Modified By NT AUTHORITYSYSTEM

Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Could not retrieve item from the queue.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)


On the same box, I used telnet to step through thge SMPT mail send process. It worked fine, indicating no firwewall, router or other issues.


I am of the opinion that Database mail is defective. This post is similar to another I have done, but no usefull responses have been made.
I am hoping that sonmeone will provide some useful information here

This is running on Windows 2003 Standard, and on SQL Server workgroup edition.
I have a second backup server similary configured that behaves exactly the same.