Thursday, January 10, 2019

Few issues after changed Office 365 subscription from E3 to Business Premium

After changed subscription from E3 - Office 2016 to Business Premium - Office 2013, I ran into all kinds of problems. 

The first issue is the Office apps such as Word shows expired ProPlus license has expired even ProPlus has been uninstalled.


The 2nd issue is after the license issue has been fixed, I could not save files to SharePoint or Onedrive for Business in Word or Excel. It would keep prompting for login even I typed in correct credential.

Solution to 1st issue:

1. Run cmd as the admin
2. CD C:\Program Files (x86)\Microsoft Office\Office15 (Office 16 for Office 2016) or CD C:\Program Files\Microsoft Office\Office15  and press Enter.
3. Run cscript ospp.vbs /dstatus and press Enter (copy the last five digits of the product key for Office 16O365ProPlus).
4. Run cscript ospp.vbs /unpkey:xxxxx

Solution to 2nd issue:

Make sure "Modern Authentication for Office 2013" is enabled (Office 2016 is enabled automatically).

Check the registry and make sure those two keys below present.


Registry keyTypeValue 
HKCU\SOFTWARE\Microsoft\Office\15.0\Common\Identity\EnableADAL REG_DWORD 
HKCU\SOFTWARE\Microsoft\Office\15.0\Common\Identity\Version REG_DWORD 
https://docs.microsoft.com/en-us/office365/admin/security-and-compliance/enable-modern-authentication?view=o365-worldwide

Friday, January 4, 2019

After mailbox migration to O365, the mailbox did not move to disconnected mailbox

We have been migrating mailboxes from on-prem Exchange 2010 to O365. All was good except two mailboxes. After migration was successful, these two mailboxes did not move to 'disconnected mailbox' status as they should be. Therefore, all external emails and O365 went to O365 that users can view them in OWA and on-prem emails went to their Outlook because Outlook is connected to on-prem Exchange automatically instead of O365.

Solution: (by Awesome MS support)

1. Disable the mailbox in Exchange Management Console on Exchange 2010 or use the command below. My case I use GUI.
Disable-Mailbox -identity -<user_identity_email>
2. Issue the next command
Enable-RemoteMailbox "<user_identity_email>" -RemoteRoutingAddress "<user@mydomain.mail.onmicrosoft.com>"
3. Run a Azure delta sync - (or full sync)
Start-ADSyncSyncCycle -PolicyType Delta
Start-ADSyncSyncCycle -PolicyType Initial
4. Create a new Outlook profile which should connect to O365.

Thursday, September 13, 2018

This action requires Windows administrator permissions - Quickbooks Enterprise issue

Running Quickbooks Enterprise on Microsoft Remote Desktop server (2018), users get "This action requires Windows administrator permission" prompt from times to times. A reboot of RDP server will fix the issue temporarily but not good enough.

There's already a lot of information on Internet suggesting to turn off UAC and change the Quickbooks database services logon to local system account. For example, I'm running Quickbook Enterprise 18 and I would change the login account to "Local System account" in "QuickBooksDB28" service.

However, that was not enough to fix this issue. I went to User Account in Control Panel, then changed the user, "QBDataServiceUser28" from User group to Administrators, and restarted the service. That seemed to fix the issue.

Wednesday, August 1, 2018

Domain Account Keeps locking out

One domain user's account keeps locking out. I have checked the credential manager to remove all without luck till I found this article at this link, https://joshancel.wordpress.com/2017/01/10/hidden-stored-credentials/.

Summary:

To resolve I found these below steps.

Download PsExec.exe from http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx and copy it to C:\Windows\System32 .
From a command prompt run:    psexec -i -s -d cmd.exe
From the new DOS window run:  rundll32 keymgr.dll,KRShowKeyMgr
Remove any items that appear in the list of Stored User Names and Passwords.  Restart the computer.

Wednesday, July 25, 2018

Unable to Share files from OneDrive for Business in File Explorer

The error is "Sorry, we're unable to reach the server right now. Please try again later."

The solution is to uncheck "Do not save encrypted pages to disk" in IE, Internet Options/advanced tab.

Friday, July 20, 2018

Reset Excel Profile in Registry

Reset Excel profile in registry if Excel is acting up.
  1. Exit Excel 
  2. Open Registry (regedit)
  3. Browse to \HKEY_CURRENT_USER\Software\Microsoft\Office\15.0 (Office Version 2013)
  4. Right click Excel and rename to ExcelOLD 
  5. Launch a blank Excel and close it to recreate Excel key

Few issues after changed Office 365 subscription from E3 to Business Premium

After changed subscription from E3 - Office 2016 to Business Premium - Office 2013, I ran into all kinds of problems.  The first issue i...