Search

MachPanel Knowledgebase

HOW TO:Added Setting of EWSAccess in mailbox features

Mudesira Munir
MachPanel

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

==============================================================
Details
Type: HOW TO
Level: Beginner
Last Modified: 6 Months Ago
Last Modified By: mudesira.munir
Article not rated yet.
Article has been viewed 723 times.
Options
Also In This Category
Tags