The information in this article applies to MailMarshal and was first reported on July 13, 2001.
DESCRIPTION
You have updated MSDE to service pack 3 or have re-configured database login settings.
SYMPTOMS
Cannot connect to the MailMarshal or WebMarshal Database.
Error: "…….Login failed for user 'sa'. Reason : Not associated with a trusted SQL Server connection……."
CAUSE
MailMarshal and WebMarshal do not support NT Authentication.
WORK AROUND
You need to edit the registry key that tells MailMarshal and WebMarshal how to connect to the database. Open the registry editor by selecting:
Start : Run
Then type "regedit"
When the registry editor opens, go to
"HKEY_LOCAL_MACHINE : SOFTWARE : Microsoft : MSSQLServer : MSSQLServer"
Then double click on the entry that says "LoginMode" and set the value to "0"
"0" (zero) = logon using Mixed Mode Authentication
"1" (one) = logon using Integrated or NT authentication.
You will need to restart your computer for these changes to take effect.