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

Wednesday, March 28, 2018

Unlock worksheet vs unlock workbook

Scenario 1
Unlock worksheet ( file is open but Workbook is protected)
Solution: upload to Google Docs and download as regular Excel file.

Scenario 2
Unlock workbook (unable to get into the file because is password protected) (Source:https://community.spiceworks.com/topic/328118-need-to-unlock-a-password-protected-excel-2010-workbook?page=5)

"Press ALT   F11 or click on View Code in Developers Tabs
In the visual basic Enter the below Code. Do not change the code just copy paste:

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5:"
You can also click on module one by one (Or on which workbook password is applied) on left side and then paste and press F5.

Thursday, February 1, 2018

Back up CUCM and UNITY to SFTP server on Windows Server

I'm replacing an old Window 2003 server hosting freeFTPd app for Cisco Call Manager and Unity backup files with a Windows 2008 R2 server.

I got the freeFTPd downloaded to the new server but had very hard time to get it to work. CUCM could not communicate with it. WinSCP could not connect to it either. After messing around the firewall settings, I gave it up on freeFTPd.

Then I decided to try the free version of SolarWinds SFTP/SCP server, WOW it only took me few minutes to get the backup to work.

On SFTP server, create the root directory, I also created two sub-folders to separate backup files between CUCM and UNITY.

 Create a new user. The credential will be used in CUCM and UNITY.

 Make sure the SFTP server is running.

On CUCM, go to Disaster Recovery System, create a new backup device.
Host name/IP address: enter the IP of the Windows server running SFTP
Path name: /CUCM (the sub-folder created in the root directory)
Username and password: same credential created in SFTP


It worked much better than the setup with FreeFTPd server based on my experience.


Monday, January 8, 2018

Prevent users accidentally move the top level folders

All top-level folders are shown in the file server share below. To prevent users from accidentally moving or deleting any of the top-level folders, the "Delete" permission needs to be removed.

Steps:
  1. Right click a top-level folder, Security tab, Advanced, select the user/group and click Change Permissions button, click Edit and un-check allow Delete.







Azure MFA NPS extension stopped working due to expired certification

 Users complained they were unable to log in VMware Horizon Client portal and the logon stuck at "Authenticating...." screen. So I...