error in Database mail in sql2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

error in Database mail in sql2005

Author

Topic

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-02 : 00:03:37

hi

i have use database mail in sql server2005 to send mail.
i have complete all step to configure databasemail.but test the mail
the error is "database mail stoped.Use sysmail_start_up to start database mail .

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-02 : 00:06:29

Your error says answer. Did you enable database mail in SQL surface area config.

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-02 : 00:22:43

after enable database mail in sql surface area config i have same error

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-02 : 00:24:45

"Use sysmail_start_up to start database mail "

Did you try this to start database mail? Did you configure outlook express?

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-02 : 00:40:40

thanks sodeep it is work
but i have test then following logs error
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
===================

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 20:55:46

How did you configure db mail? Points to valid smtp mail server? Db mail doesn't need outlook by the way.

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-05 : 00:21:35

hi
i have apply following link step to configure database mail
http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005.aspx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-05 : 23:16:57

How about smtp mail server? Is it valid on your network?

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-06 : 00:19:52

hi
thanks to all
my database mail is working

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources