February 22, 2010 at 1:08 pm
Hi All,
I'm not able to send testmail and the DBMail log is showing "Activation Failure". I'm not sure what's wrong!!
Please give me a lead guys.
Its been hours since I started working on this but still not able to figure out, pls help me out!!!
Thanks in advance!!
February 22, 2010 at 1:14 pm
Is DBMail enabled on the server?
If so, does it have a profile set up?
If so, is the account information correct?
If so, are you calling sp_send_dbmail with the correct parameters?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 22, 2010 at 1:25 pm
Is DBMail enabled on the server?
DBMail is enabled on the server, checked in Surface Area Configuration.
If so, does it have a profile set up?
Yes, I have set up a profile.
If so, is the account information correct?
The account information is correct. I say that without any doubt because, I'm able to receive test mail with the same profile in the other server!!!
If so, are you calling sp_send_dbmail with the correct parameters?
Yes, I'm calling with the right parameters.
Thanks
February 22, 2010 at 1:39 pm
Is SQLServer Errorlog showing any extra info regardnig dbmail ?
If not, post your dbmail ddl
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2010 at 1:53 pm
SQL Error Log is not showing any related error.
I'm executing this statement
exec msdb.dbo.sp_send_dbmail @recipients='my email address', @body = 'TestMail'
February 22, 2010 at 3:40 pm
I don't see the profile name used here ...
EXEC sp_send_dbmail @profile_name='DBA',
@recipients='x@hello.com',
@subject='Hello',
@body='This is an automated message.'
-VG
February 22, 2010 at 4:16 pm
No luck! It just shows "Mail queued"
Please do let me know is you guys have an update.
Thanks a lot for your time!:-)
February 23, 2010 at 2:14 am
I always use these scripts to diagnose DBMail issues ...
use msdb
go
/* is dbmail config activated ? */
Select *
from sys.configurations
where [name] = 'Database Mail XPs'
go
exec sysmail_help_queue_sp -- @queue_type = 'Mail'
go
select *
-- delete
from sysmail_event_log
order by log_date desc
select *
from sysmail_mailattachments
select *
from sysmail_allitems
order by sent_date
/* show failed stuff */
SELECT SEL.event_type
, SEL.log_date
, SEL.description
, SF.mailitem_id
, SF.recipients
, SF.copy_recipients
, SF.blind_copy_recipients
, SF.subject
, SF.body
, SF.sent_status
, SF.sent_date
FROM dbo.sysmail_faileditems AS SF
JOIN dbo.sysmail_event_log AS SEL
ON SF.mailitem_id = SEL.mailitem_id
/*
********** cleanup old messages **********
Declare @sent_before datetime
Select @sent_before = dateadd(MM,1,dateadd(dd,datediff(dd,0,getdate()),0))
print convert(varchar(26),@sent_before,121)
exec sysmail_delete_mailitems_sp @sent_before = @sent_before
, [ @sent_status = ] 'sent_status' ]
delete from sysmail_event_log where log_date < @sent_before
*/
/*
SELECT [account_id]
,[name]
,[description]
,[email_address]
,[display_name]
,[replyto_address]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_account]
SELECT [attachment_id]
,[mailitem_id]
,[filename]
,[filesize]
,[attachment]
,[last_mod_date]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_attachments]
SELECT [transfer_id]
,[uid]
,[filename]
,[filesize]
,[attachment]
,[create_date]
FROM [msdb].[dbo].[sysmail_attachments_transfer]
SELECT [mailitem_id]
,[profile_id]
,[recipients]
,[copy_recipients]
,[blind_copy_recipients]
,[subject]
,[body]
,[body_format]
,[importance]
,[sensitivity]
,[file_attachments]
,[attachment_encoding]
,[query]
,[execute_query_database]
,[attach_query_result_as_file]
,[query_result_header]
,[query_result_width]
,[query_result_separator]
,[exclude_query_output]
,[append_query_error]
,[send_request_date]
,[send_request_user]
,[sent_account_id]
,[sent_status]
,[sent_date]
,[last_mod_date]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_mailitems]
SELECT [profile_id]
,[principal_sid]
,[is_default]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_principalprofile]
SELECT [profile_id]
,[name]
,[description]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_profile]
SELECT [profile_id]
,[account_id]
,[sequence_number]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_profileaccount]
SELECT [uid]
,[text_data]
,[create_date]
FROM [msdb].[dbo].[sysmail_query_transfer]
SELECT [conversation_handle]
,[mailitem_id]
,[send_attempts]
,[last_send_attempt_date]
FROM [msdb].[dbo].[sysmail_send_retries]
SELECT [account_id]
,[servertype]
,[servername]
,[port]
,[username]
,[credential_id]
,[use_default_credentials]
,[enable_ssl]
,[flags]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_server]
SELECT [servertype]
,[is_incoming]
,[is_outgoing]
,[last_mod_datetime]
,[last_mod_user]
FROM [msdb].[dbo].[sysmail_servertype]
*/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2010 at 8:10 am
"Mail queued" is what it's supposed to show. That means it's in the queue to send and should go.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 23, 2010 at 11:01 am
Thanks for the updates guys!!
Well, it just says "Mail queued" but it doesn't get delivered though!!
Just a passing thought, is this in any way related to the SQL Server 2005 SP2?
Thanks
February 23, 2010 at 11:56 am
You should also check your mail server, because it may withhold your mail because of e.g. spam settings, ...
Regarding your SP2 question:
SP2 has many cumulative hotfixes (as does SP3), so post your buildnumber to be able to exactly interpret your question.
(This way we can find out at which CU level your instance is)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2010 at 5:18 pm
We are using SQL Server 2005 Enterprise Edition 64-Bit Build 3790: SP2
Thanks
February 24, 2010 at 12:03 am
I don't know the 3790 build.
Please post the full result of
Select @@version
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 24, 2010 at 2:43 pm
There you go,
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks
February 24, 2010 at 11:54 pm
KingCobra (2/24/2010)
There you go,Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks
SQL build 9.00.4035.00 is SP3 .
Please post your dbmail install script.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply