Summary
This article provides information on new feature / enhancement Setting of EWS access added in mailbox features.
Applies To
It applies to MachPanel build v7.2.35 and above.
Details: Could not Connect to OWA/EWS on all new mailboxes
Problem is due to EWSEnabled = False in new mailboxes created.
Execute below PS script on Exchange server(s):
To get EWS Access Enabled, execute below PS script on Exchange server(s):
Get-CASMailbox -ResultSize "Unlimited" | where {$_.EWSEnabled -eq $false} |Set-CASMailbox -EWSEnabled $true
SQL Query / CMD:
To set EWS enabled on existing and new mailboxes run below query in SQL database after logging as MachPanel_Db user:
================================================================
Declare @ResourceId int
Set @ResourceId = (Select ResourceId from HB_tblResources Where ResourceInternalID=525) --EWSEnabled in CAS policy
Declare @MAPIResource int
Set @MAPIResource=(Select ResourceId from HB_tblResources Where ResourceInternalID=292)
Update HB_tblPackagesDetail
Set ResourceQuantity=
IsNull((Select ResourceQuantity from HB_tblPackagesDetail PD Where PD.ResourceID=@MAPIResource and PD.PackageID=HB_tblPackagesDetail.PackageID),0)
where ResourceID=@ResourceId
Update HB_tblAddonTypeDetail Set ResourceQuantity=
IsNull((Select ResourceQuantity from HB_tblAddonTypeDetail AD Where AD.ResourceID=@MAPIResource and AD.AddonTypeId=HB_tblAddonTypeDetail.AddonTypeId),0)
where ResourceID=@ResourceId
Update HB_tblPackagesSoldDetail
Set ResourceQuantity=
IsNull((Select ResourceQuantity from HB_tblPackagesSoldDetail PD Where PD.ResourceID=@MAPIResource and PD.SoldPackageID=HB_tblPackagesSoldDetail.SoldPackageID),0)
where ResourceID=@ResourceId
Update HB_tblAddonsSoldDetail Set ResourceQuantity=
IsNull((Select ResourceQuantity from HB_tblAddonsSoldDetail AD Where AD.ResourceID=@MAPIResource and AD.SoldAddonId=HB_tblAddonsSoldDetail.SoldAddonId),0)
where ResourceID=@ResourceId
Update Hb_tblExchangeMailBoxTemplates Set EWSAccess=MAPIAccessAllowed
Update HB_tblExchangeMailboxDetail Set EWSAccess=MAPIAccess
==============================================================