August 18, 2009 at 2:58 pm
Here is my goal:
Create a database that holds email messages that can be queued to send through a SP using sp_send_dbmail. My SP takes the usual To, Subject, Body, Priority, Attachments and Profile to use.
Here is the sticky part.
We will have several applications saving to the SQL Table. We have several companies under our Corp umbrella and some of the individual customers of each company should not see the domain name of our parent company.
Parent Company = Parent.com
Child 1 Company = Child1.com
Child 2 Company = Child2.com
Child 3 Company = Child3.com
Our Exchange Server is on Parent.com and is configured to relay messages from our SQL Server 2005 box.
Child 2 customers should only see messages as coming from Child2.com. I have created a Profile in DBMail that will send using the [from] address as noreply@Child2.com.
Problem is if someone looks at the email header, it shows it as being sent from Parent.com.
Is there a way that I can “spoof” the correct domain using the Profile set up for Child2.com in DBMAIL?
Someone told me I could somehow use a SMTP Domain, set up in IIS SMTP Service, but I am not sure how to impiment that Domain in the Server field in the DBMAIL Profile Account.
Any help would be appreciated, and no we are not using this to SPAM people, it is for a legitimate purpose.
Thanks much,
Kim
August 19, 2009 at 6:09 am
Hi Kim,
Although it is possible to setup an SMTP relay server using IIS, the issue is that the SMTP server will have to relay to your Exchange server again (adding the parent domain to the header...). Using SMTP relay servers opens a lot of security holes as well, so I wouldn't recommend doing it unless you fully understand the configurations, etc.
Are all the child domains using the same Exchange server on the parent domain? Could you not set different DB Mail profiles up per domain relaying through each separate Exchange server?
HTH 🙂
August 20, 2009 at 10:48 am
Danie Loots (8/19/2009)
Are all the child domains using the same Exchange server on the parent domain? Could you not set different DB Mail profiles up per domain relaying through each separate Exchange server?
No, we are just using 1 Exchange Server
August 20, 2009 at 1:04 pm
I might be mistaken, but If I recall correctly you can setup different connectors, possibly even on different IP's on Exchange so that messages sent to that internal IP get sent out under that domain. Now, you still will have the issue if you are behind a firewall, as your external/public address will be one and the same, and if that IP address is mapped to a RDNS pointer, it will still state as coming from the same "domain". You would need separate conduits on the firewall, with different addresses mapped to the inside in that case.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply