Database Mail issue

Question

Database Mail issue

jude-32296

Default port

Points: 1412
More actions
July 14, 2011 at 9:15 am

#253766

I recently created an instance on a server & database mail was setup the same way as on the original instance, and yet the new instance will send a test message from the Database Mail object under Management, but not for a user who has a " ' " in his email address.
Logs & tables I queried for mail troubleshooting are not presenting any errors, in fact it says 'sent' 'started', etc.
His email address is input as person.d"person@here.com, know we cannot use an apostrophe. It works fine on the original instance, but not the new instance.
Any ideas of what I could have missed when setting up dbmail on my new instance?
thx

Viewing 4 posts - 1 through 3 (of 3 total)

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

jude-32296 Default port Points: 1412 More actions · Answer 1

Now i messed around and am receiving an error message " Cannot send mails to mail server. The remote certificate is invalid according to the validation procedure"

jude-32296 Default port Points: 1412 More actions · Answer 2

The first part of my problem is still an issue.

The certificate thing was a result of the profile not being set as default = Y

Lowell SSC Guru Points: 323518 More actions · Answer 3

you'll have to show the code that is being called to send the mail...it sounds like you might be building a string, instead of using parameters.

if you are building a string, you have to take the possibility of single quotes in the data into consideration.

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!