June 15, 2007 at 6:30 am
hi to all,
I'm trying to setup the sql 2005 database mail, but when I launch the test e-mail, in the event log, I have this error:
Log ID 48
Process ID 3520
Last Modified 15/06/2007 10.04.33
Last Modified By NT AUTHORITY\SYSTEM
Message
Could not retrieve item from the queue.
I tried to stop and restart mail service, delete the existing profile/account and recreate it.
the smtp server is up and runs correctly (I tried to send/receive mail using it on ms outlook)
Anyone have an idea to solve this problem?
Thank you very much in advance,
Alex
June 15, 2007 at 7:04 am
The profile is not properly created. Try executing the procedure and check whats the error it throwing.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 15, 2007 at 8:00 am
It is probably security related.
Hope this helps
Mark
June 15, 2007 at 9:59 am
Hello Mark,
many thanks for your help!
The database mail was enabled cecking the box in the SQL Surface area configuration.
The account I use to log in , is the local administrator of the server. I looked to the server roles in sql but I didn't find neither the sqladmin role nor the databaseMailUserRole..
Could you help me, please?
Thank you very much in advance,
Alex
June 15, 2007 at 10:39 am
Sorry, I meant to say "sysadmin" not sqladmin. If you are local Admin on the server, you should have sysadmin privileges.
DatabaseMailUserRole is used for enabling non-admin users to use Database Mail. Check BOL for Database Mail - Troubleshooting for info on checking who is in the role and adding users to it.
Hope this helps
Mark
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply