Using VIEWS for Database Mailboxes Using Databse mailboxes with "VIEWS" in SQL Server for Mailbox authentication

MailSite can be configured to use "views" within SQL Server however this configuration is NOT supported by Rockliffe Technical Support.

Below are some items to check if you choose such configuration.

• Ensure your "VIEW" displays the following columns

                    Mailbox (Primary key)
                    FullName
                    Password
                    Domain

Should you choose different names for the attributes, then you will need to specify these names within the "Generic Database Configuration" in the MailSite console.

• You should also ensure you install/reinstall latest version of MDAC (2.7), which can be obtained from the Microsoft Website. 

 

For assistance from Rockliffe Technical Support, you need to be using a Table for MailSite to authenticate against.