Database Mail does not work on New Server

Question

Database Mail does not work on New Server

Viewing 8 posts - 46 through 52 (of 52 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Thanks Lowell. 🙂

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/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

ok, I have another Server that was just handed over to me late Thursday.

I just installed SQL Server & I ran the script on a prior post in this thread but I check the log and I have the folloing error:

Date4/7/2012 2:57:54 PM

LogDatabase Mail (Database Mail Log)

Log ID2

Process ID5092

Mail Item ID1

Last Modified4/7/2012 2:57:54 PM

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-04-07T14:57:54). Exception Message: Cannot send mails to mail server. (Server does not support secure connections.).

)

Any ideas?

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/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Can you verify the settings on the servers that are working. The error message indicates that the mail server is not setup to accept ssl connections and you are enabling ssl.

Lowell SSC Guru Points: 323518 More actions · Answer 4

i think if you look at the profile, the checkbox for "This server requires a secure connection(SSL) is checked.

the error message says the mail server doesn't support SSL for that service, so just uncheck it.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Lowell, that fixed it.

I do not understand why it does not work on the other machine.

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/

Lowell SSC Guru Points: 323518 More actions · Answer 6

welsh can you go to one of your servers you know you already set up and is working, and use my script to reverse engineer database mail settings?

then you can run the script on the trouble server...maybe that will help, because the settings would be the same;

you have to change the smtp password is the only change it requires, since passwords cannot be scripted out of a credential:

Reverse_Engineer_Mail_Settings.sql.txt

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

Thanks Lowell, I tried that but I did not see any differences other than The descriptions that I used.

For some reason I do not have access to the machine.config file.

I have been searching the internet but I have found that much.

THe following says to download a program so that you can identify which user is attempting to open the file.

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/c0d61887-6ea5-4d21-b234-38cd2e4491f4/

Message: An error occurred loading a configuration file: Access to the path 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config' is denied. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config)

BareMessage: An error occurred loading a configuration file: Access to the path 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config' is denied.

Filename: C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config

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/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

It is running on Windows Server 2008 R2 which has tightened up security..

I setup another machine last weekend running the same OS and no problem,

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/