FAQ

Q: How Do I Configure versaCAT to Authenticate Against a versaCRM Managed Contact

A: The example below shows how to configure the web.config of versaCAT to authenticate against a versaCRM managed contact. The example assumes that versaCAT is configured for Forms-based authentication and the versaCAT user's username and password is defined by their email address (Email 1) and Fax (Fax 1) respectively, recorded against the versaCRM Business Address of the Contact.

    <add key="ClientValidationMode" value="1" />
    <add key="ClientValidationDSN" value="provider=SQLOLEDB.1;data source=DatabaseServer; initial catalog=VersaCRM;uid=Username;pwd=Password"/>
    <add key="ClientValidationQuery" value="SELECT Fax2 AS Password, EmailAddress1 As Email FROM tbl_VCRMAddresses WHERE ParentTypeID = 2 AND AddressNumber = 1 AND AddressTypeID = 1 AND EmailAddress1 = '[USERNAME]'"/>

where DatabaseServer, Username and Password are set appropriately.

Did the information in this article help answer your question?

Yes
No
Did not apply