New Server Role Causes Default Domain Name to Change and not be able to add new Accounts

You have added a new server role and have migrated the server you are working on to this new role. Then when expanding the domains tree, within the MailSite Console the default domain name has changed to the fully qualified domain name of the server.  When attempting to add a new mailbox you receive an error and the mailbox is not created.

To address this issue you need to apply these changes to the MailSite Database

1. Open the table MailServerProperties
2. Perform a search for the PropertyName - 'DefaultDomainName'
3. Make sure all the role or roles have the same Default Domain Name, save and close the table
4. Open the Stored Procedure 'countmailboxes'
5. Within the Stored Procedure you will see a line like this

   'WHERE ServiceName = 'server' AND PropertyName = 'defaultdomainname')'

   this needs to be changed to

   'WHERE ServerRoleId = 0 AND ServiceName = 'server' AND PropertyName = 'defaultdomainname')'

   Save and close the Stored Procedure.

This will make all roles use the same Default Domain Name and allow the creation of new email accounts.