November 20, 2008 at 6:35 am
Guys and Galls
I am trying to set up Database Mail on my server.
I have run through the configuration wizard (easy way out I know) and the server wont email out.
I have run sp_configure to enable database mail.
The user is a member of builtin administrators with full sysadmin roles on the server to execute to role of DatabaseMailUser in MSDB.
The SQL Server Service and SQL Server Agent both run as the same user (I know this was required for SQL Mail in 2000)
This is the result from this quering msdb.dbo.sysmail_allitems
2701,4,anthony.green@enterprise.plc.uk,NULL,NULL,Automated Success Message,The stored procedure finished successfully.,TEXT,NORMAL,NORMAL,NULL,MIME,NULL,NULL,0,1,256, ,0,0,2008-11-20 13:21:49.283,SITES\agreen,NULL,failed,2008-11-20 13:22:49.000,2008-11-20 13:22:49.300,sa
Any help would be appriciated to get this working.
Thanks
Ant
November 20, 2008 at 7:07 am
check in the logs..what error do you get..i just did setup db mail yesterday and i was also getting some error...paste the error here..somone will be able to help u out..
November 20, 2008 at 7:14 am
Date20/11/2008 13:22:49
LogDatabase Mail (Database Mail Log)
Log ID2820
Process ID7492
Mail Item ID2701
Last Modified20/11/2008 13:22:49
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2008-11-20T13:22:49). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it).
)
This is the error,
SQL Server Service and Agent run as sites\pmacsemail
SQL Database Mail is using the service authenticate to Exchange.
Ant
November 20, 2008 at 8:03 am
I'll double check the SMTP server is reachable from the SQL Server
The error log did seem to indicate that way, not login failure or mail rejected etc...
November 20, 2008 at 8:10 am
The SQL Server can ping the exhcange server and outlook opens on the server with the same profile and pulls back all emails from the exchange server, so connectivity is not an issue.
Ant
November 21, 2008 at 6:26 am
I was under the impression DB Mail will only work with SMTP. Is SMTP enabled on the Exchange server and is it set up to accept annonymous connections?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 21, 2008 at 6:37 am
The issue is now resolved, there was a rule blocking the server from connecting to the exchange server.
Our exchange servers are set up for SMTP.
I know the account has an exchange mailbox, but I dont know if it is routing through SMTP to Exchange
Ant
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply