Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem with Database mail


Problem with Database mail

Author
Message
Nassan
Nassan
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 849
do you have any server Database mail does work properly? if you do you may try and compare the configurations differences and if you could not find anything, you may have to reinstall the server(sql server)
lkennedy76
lkennedy76
Old Hand
Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)

Group: General Forum Members
Points: 362 Visits: 771
...sorry wrong post

MCSA SQL Server 2012
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5218 Visits: 4876
Massan (3/25/2013)
do you have any server Database mail does work properly? if you do you may try and compare the configurations differences and if you could not find anything, you may have to reinstall the server(sql server)


I would avoid reinstalling SQL Server if at all possible.

Can the OP get Database Mail working on any Server?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
rador
rador
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 57
Did you find an answer to this problem? I have 2 instances of SQL Server running with what appears to be the exact same configuration and one sends mail and the other does not. All my tests in the problem instance show as "unsent". No failures, just "unsent".


I've run all the sysmail sprocs and am thoroughly aware of all the information they provide. I've recreated the one mail profile. The accounts running the mail appear to have adequate priviledges. And, the mail runs from another instance with the same configuration? Have you found any clues?



Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5218 Visits: 4876
rador (3/12/2014)
Did you find an answer to this problem? I have 2 instances of SQL Server running with what appears to be the exact same configuration and one sends mail and the other does not. All my tests in the problem instance show as "unsent". No failures, just "unsent".


I've run all the sysmail sprocs and am thoroughly aware of all the information they provide. I've recreated the one mail profile. The accounts running the mail appear to have adequate priviledges. And, the mail runs from another instance with the same configuration? Have you found any clues?


Yes it had to do with the Service Account. Are you using a Domain or Local Account?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
rador
rador
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 57
Corgi, Thanks for a quick response. How do I find the account being used to actually send the mail? In sysmail_allitems a request has been made by a local account (NT Authority\System) and last modified by 'sa'. The SQL Server Agent has windows authentication selected in the connecting tab. I don't have access to the server itself, but I can get someone that does and get them to check what accounts are being used in the services.



isd83
isd83
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 574
I am having the same issue of DB mail got stuck. I noticed if I turn the sql browser service to start, the db mail will send out the message. I don't think that DB mail requires sql browser service to be running.



dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 1958
I may have said this earlier and I'll say it again - if mail won't send and you know the settings are correct because they match a different server that does work, check local anti-virus settings and talk to the person in charge of the email server security settings.

As you know, trojans taking over servers to send spam is a huge problem, and measures to prevent this may very well interfere with SQL Database mail.
rador
rador
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 57
I agree that security measures could be the cause. I could not get help from the local admin until I convinced them to let me try an experiment at the server. While there, I noticed a McAffe HIPS console with lots of funny red words that said attack. The admin said that had been going on for months but they couldn't do anything about it. I nearly fainted. I cajoled them to contact admins that were upstream to put an exception in place. It works fine now.



dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 1958
Classic left-hand/right hand situation.

The left hand can't figure out why SQL Server Database Mail doesn't work, and the right hand can't figure out why an anti-virus program alarms like crazy because something on the server is trying to send mail.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search