Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Problem with Database mail Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 8:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 8, 2014 8:36 AM
Points: 36, Visits: 718
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)
Post #1434948
Posted Monday, March 25, 2013 9:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 10:25 AM
Points: 301, Visits: 595
...sorry wrong post

MCSA SQL Server 2012
Post #1434964
Posted Monday, March 25, 2013 10:34 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:44 PM
Points: 4,240, Visits: 4,284
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/

Post #1435028
Posted Wednesday, March 12, 2014 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:12 AM
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?



Post #1550318
Posted Wednesday, March 12, 2014 10:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:44 PM
Points: 4,240, Visits: 4,284
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/

Post #1550346
Posted Thursday, March 13, 2014 1:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:12 AM
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.


Post #1550906
Posted Wednesday, August 6, 2014 2:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 5:19 PM
Points: 56, Visits: 572
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.


Post #1600390
Posted Wednesday, August 6, 2014 3:07 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:28 AM
Points: 553, Visits: 1,618
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.
Post #1600408
Posted Wednesday, August 6, 2014 4:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:12 AM
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.


Post #1600419
Posted Wednesday, August 6, 2014 10:01 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:28 AM
Points: 553, Visits: 1,618
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.
Post #1600456
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse