KB Article #101119

EMF appends the local hosts domain to incomplete SMTP addresses

EMF appends the local hosts domain to incomplete SMTP addresses

Summary:

> I believe that EMF adds the local domain on SMTP senders and recipients
> that are missing the domain, eg, if the SMTP recipient is xyz@attbi (ie,
> without the ".com"), EMF will make it xyz@attbi.localdomain.com.
>
> 1) Is this true?

Yes.

> 2) Can you turn this feature off?

Yes. (details below)

Resolution:

To turn off this feature, you'll need to set the configuration parameter named 'Default Domain' in the RelayConfigValues table to have an ansiStringValue equal to an empty string (but not a NULL SQL value). To insert the row, with an empty string value, use the script:

INSERT INTO RelayConfigValues
(keyName, ansiStringValue, lastUpdate)
VALUES ('Default Domain', '', GETDATE())

NOTE: there are two successive single quotes in the second parameter of the VALUES clause.

Here are instructions to run the script:

  • stop the EMF services
  • open and log into Query Analyzer
  • make sure the droplist at the top says MMSMail
  • select Window > View Results Pane
  • in the upper window, copy and paste the script
  • press the green arrow in the toolbar
  • lower window should say 1 row affected
  • close Query Analyzer
Verify the change:
  • open SQL Enterprise Manager
  • open Databases > MMSMail > Tables
  • right-click on RelayConfigValues > Open table > Return all rows
  • verify that the row labeled Default Domain is there with an empty string value