Excel cannot access BloombergUI.xla. The document may be read-only or encrypted.

Issue description: When you launch Microsoft Excel 2016 you get below error message: When Excel is Opened -> Bloomberg Tab -> When you click on Refresh then below error is displayed: Troubleshooting For troubleshooting this issue, you can perform below steps: Make sure C:\blp and its subfolders are excluded from Anti-virus Scanning. For SentinelOne, Add the folder to exclusions in Interoperability mode as shown below: Exclude c:\blp folder from Windows Defender Scanning using below commands on PowerShell window on the affected system. Use setpermissions.exe to set the correct permissions on Bloomberg folders and bloomberg registry keys. Run this exe as administrator it automatically checks and fixes the permissions for you. …

Read more

Copy Files between ESXi Hosts by using SCP (Secure Copy) Command / SCP Copy Stalled Fix

scp allows files to be copied to, from, or between different hosts. It uses ssh for data transfer and provides the same authentication and same level of security as ssh. Enable SSH on ESXi Hosts First make sure the Port 22 is open between source and destination ESXi host . If its not, the you can fix it using below steps: On source and destination ESXi hosts make sure TSM-SSH Service is in Running State. Make sure SSH Client in ESXi Networking Firewall rules is Enabled on both source and destination ESXi hosts in Networking -> Firewall rules -> SSH Client. Click on Actions and then Enable. Test Port 22 Connect to Source ESXi …

Read more

Unable to delete Azure resource tag from few resources like Microsoft insights using Azure Portal

Recently worked on an issue where I was not able to remove resource tags from couple of resources using azure portal. The specific resource type was microsoft.insights\scheduledqueryrules. Selecting the resource and clicking on the three dots -> click Edit tags -> try to remove the tag, you will get a notification saying that its successfully deleted but when you check the tags on the resource its not removed. I had a ticket logged with MS product team for this issue and they suggested below workaround. To delete the tag from microsoft.insights\scheduledqueryrules when its not getting deleted using azure portal. Please follow below steps: GET the resource output in Json Code …

Read more

Export Users DisplayName, UsageLocation, UserPrincipalName, MFA Status, StrongAuthInfo, DefaultAuthMethod from office 365 / Azure AD using PowerShell in CSV

You can export Office365 users DisplayName, UsageLocation, UserPrincipalName, MFA Status, StrongAuthInfo, DefaultAuthMethod using powershell. The exported data will be in a CSV File which will list these details. Default MFA Method is useful when you want to know who in your company is using which MFA method to authenticate to office365 services. For example, this data is also useful when you are planning to move the users from SMS based method to Phone App Method which is more secure. The PhoneAppNotification method means when users will get notification in MS Authenticator App and they tap on approve to confirm sign-in. First you need to download / Install MSOnline powershell module …

Read more

Outlook and Teams not launching, Error code 80090016. Your computer’s Trusted Platform Module has malfunctioned.

When you launch Outlook and Teams on Windows 10 workstation, you may receive the below error: Microsoft Office Version being used Microsoft 365 MSO 16.0.13127.21062 (Microsoft 365 Apps for enterprise) Screenshot: Solution: Logoff current user. Login on the workstation using administrator account. Go to C:\users\<user account having issue>\AppData\Local\Packages\Microsoft.AAD.BrokerPlugin_cw5n1h2txyewy Rename Microsoft.AAD.BrokerPlugin_cw5n1h2txyewy to Microsoft.AAD.BrokerPlugin_cw5n1h2txyewy.old Log off from the administrator account and Login as the user. Launch Outlook and Teams, it should work fine this time. OneDrive may have been signed out as well, you can sign in to one drive as well to check if one drive is also working fine at this point. Other Solutions: The other solutions which could help …

Read more

How to configure Azure Site Recovery, perform test failover and invoke disaster recovery failover – Part 3

In the previous post How to configure Azure Site Recovery, perform test failover and invoke disaster recovery failover – Part 2 – TechPress we have seen how to perform Test Failover using Azure Site Recovery. Also, we have seen how to clean up the test failover after verification of the application services on the server. We had noted down the RPO (Recovery Point Objective) and know how much time it takes to bring up the Server during DR (RTO). If you are following along via the previous posts, you know that our primary site is UK South and disaster recovery site is UK West. During Outage in Primary Site, we …

Read more

How to configure Azure Site Recovery, perform test failover and invoke disaster recovery failover – Part 2

In the last post How to configure Azure Site Recovery, perform test failover and invoke disaster recovery failover – Part 1 – TechPress i had explained on how you can configure Azure Site Recovery and configured the Virtual network for Test Failover and Failover. When you initiate Test Failover, Site Recovery Service will use that network to start the protected servers in DR site. If you have never performed a test failover or the last test failover was failed. A warning message will be shown but you can proceed with Failover by accepting the risk and continue with the failover. However, Its recommended to perform a Test Failover before performing …

Read more

How to configure Azure Site Recovery, perform test failover and invoke disaster recovery failover – Part 1

Site Recovery service is a BCDR (Business continuity and disaster recovery) solution which keeps your azure workload running during outages. You can configure this service to replicate the workloads to secondary site. Secondary site could be referred to as DR site as well. Its a region other than your primary site. For Example, if your Azure Workload is in Azure UK South Region, you can configure UK West to be your secondary region / DR Site. You can also replicate your on-premise servers to azure via ASR and have azure as your DR site. At the time of outage, just failover to secondary site to keep your application services / …

Read more

Step by Step Implementation of Azure AD Application Proxy

Azure Active Directory’s Application Proxy service provides secure remote access to on-premises web applications. After a single sign-on to Azure AD, users can access both cloud and on-premises applications through an external URL or an internal application portal. For example, Application Proxy can provide remote access and single sign-on to Remote Desktop, SharePoint, Teams, Tableau, Qlik, and line of business (LOB) applications. Implementation of Azure Application Proxy is easy and provides secure access to your on-premise web applications without the need to open any inbound ports on the firewall. You can also integrate the solution with Multi Factor authentication like DUO or MS authenticator and Conditional Access Policies to secure …

Read more

Exchange Online / Exchange 2010 useful PowerShell Commands

Export the Access Rights / Permissions assigned to All user mailboxes in Office365. Export the Access Rights / Permissions assigned to All Shared Mailboxes in Office365 Export the Access Rights / Permissions assigned to All Shared Mailboxes in Office365 (Another Variation to Export only relevant information) List the Access Rights / Permissions for a user on all other mailboxes (Below command will list the full mailbox permissions which user1 have on all other mailboxes) Export the Access Rights / Permissions for the Calendar Folder of all User Mailboxes. Another way to List Calendar Permissions You can filter the Calendar Folder Permissions to only list it for a particular user e.g. John. …

Read more