Category Archives: Support

How to Fix sfc Error “found corrupt files but was unable to fix” and DISM Error “The source files could not be downloaded”

Machine: Asus UX303

OS: Windows 8.1 64-but

Status as at 2020-05-25:  fail to solve

  1. sfc /scannow returns this message — “Windows Resource Protection found corrupt files but was unable to fix some of them. “
  2. Run “DISM” as follows:
    1. Type “cmd” in windows search bar
    2. Right click on “Command Prompt”
    3. Select “Run as Administrator”
    4. Type “DISM /Online /Cleanup-Image /CheckHealth” without quote and press ENTER
    5. Type “DISM /Online /Cleanup-Image /ScanHealth” without quote and press ENTER
    6. Type “DISM /Online /Cleanup-Image /RestoreHealth” without quote and press ENTER
      (source: https://answers.microsoft.com/en-us/windows/forum/all/sfc-scannow-found-errors-but-couldnt-fix-all-of/663ec1fa-a215-41b8-abbb-2aa1cca703e2)
  3. If “DISM /Online /Cleanup-Image /RestoreHealth” return this message — “The source files could not be downloaded. Use the “source” option to specify the location of the files that are required to restore the feature.”
    then

    1. mount the “iso” file of the Windows
      (the “iso” file is mounted as “E:\” drive)
    2. Type “DISM /Online /Cleanup-Image /RestoreHealth /Source:E:\” without quote and press ENTER
      (source: https://www.thewindowsclub.com/dism-fails-source-files-could-not-be-found/ )
  4. Same error message appeared — “The source files could not be downloaded. Use the “source” option to specify the location of the files that are required to restore the feature.

How to Automatically Fill-In “Laporan Harian COVID-19”

Note: the report as been moved from http://survey.dosh.gov.my/laporanhariancovid19/ to https://notification.miti.gov.my, we have revised the script to automatically filled in the new report at this new post …

Quick Guide

  1. Install AutoHotkey (AHK).
  2. Select the script “DOSH v. 1.0-demo.ahk”.
  3. Run the script by double clicking on “DOSH v. 1.0-demo.ahk” file.
  4. Go to “Laporan Harian COVID-19”  at http://survey.dosh.gov.my/laporanhariancovid19/
  5. Run the hotkey according to its page number. For example:
    • on page 1, press <CTRL> then <1>, all fields on that page will be automatically filled;
    • on page 2, press <CTRL> then <2>, all fields on that page will be automatically filled;
    • on page 5 (last page), press <CTRL> then <5>, all fields on that page will be automatically filled;
  6. Finally, manually click “Hantar” to submit the report. Refer to video below for a demonstration …

Continue reading

How to Configure TLS 1.2 in Windows Server

  1. Open Windows PowerShell and copy below command into it
    # Create Keys for TLS 1.2 if not exist
    
    new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols" -Name "TLS 1.2"
    
    new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2" -Name "Server"
    
    new-item -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2" -Name "Client"
    
    new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client" -Name "Enabled" -Value 1
    
    new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client" -Name "DisabledByDefault" -Value 0
    
    new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server" -Name "Enabled" -Value 1
    
    new-itemproperty -path "HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server" -Name "DisabledByDefault" -Value 0
  2. Reboot server
  3. To check whether TLS 1.2 is configured, open Registry Editor and go to this path:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols

    in this picture, it shows that Windows has “SSL 2.0” and “TLS 1.2” security protocol installed.

(OBSOLETE) Control Panel for MobiGATE SMS Engine — Enterprise Edition version 2.6 is Released

List of  Fixes in Version 2.6

  • Engine cannot start because service is still stopping (after “Stop” button is clicked). CP shows “Stopped” but in fact service is showing “Stopping”;
  • Engine cannot stop because service is still starting (after “Start” button is clicked). CP shows “Started” bt in fact service is showing “Starting”;
  • “Modem Status” is tab “Modem 9 to 16” is not showing colours, it is showing “5” or “0” instead. Happens in MS SQL Server only (does not happen in MySQL);
  • Error message when connecting the “modem.state” table – “Location: CheckModemStatusVersion2_MSSQL Error message: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication”;
  • Error message when connecting the “modem.state” table – “Location: CheckModemStatusVersion2_MSSQL Error message: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication”;
  • Conversion from string “” to type ‘Double’ is not valid. Caused by null or empty value in “Modem_State.Status”;
  • After stop monitoring, modem ID 9 to 16 still showing modem status.By right, there should be no colour status and should be all grey colour;
  • Set the application to run as administrator automatically.

 

Download

Existing customers of MobiGATE with valid warranty period or with valid annual support programme could download version 2.6 from here … (https://www.mobitek.my/download/MOBITEK%20MOBIGATE/Setup%20–%20Control%20Panel%20v.%202.6.zip)

 

More Information

 

How to Solve mp4 Video File Cannot be Playbacked in a Web Broswer

Problem: mp4 video, “vcom-showing-connected-then-disconnected.mp4”,  in https://mobitek-system.com/blog/2017/11/vcom-showing-connected-then-disconnected/ cannot be playbacked.

 

Cause: encoding used is not supported by web browser even though the “vcom-showing-connected-then-disconnected.mp4” video can be played in Windows Media Player.

 

Suggestions: for HTML5 in general, the optimized video encoding would be H.264 for .MP4 or WEBM for .webm (refer to https://help.encoding.com/knowledge-base/article/html5-video-format-conversion-support/)

 

2 Solutions:

  1. use VLC to convert, refer to the guide in http://www.pavtube.com/vlc-convert-avi-to-mp4.html; or
  2. use https://video.online-convert.com/convert-to-mp4  to convert “vcom-showing-connected-then-disconnected.mp4” using “H.264” codec

After conversion, the video can be playbacked in web browser.

Comparison Between Role of db_owner with Roles of db_datareader & db_datawriter in MS SQL Server

  1. db_owner role should only be given to the administrator who responsible for the database because this role can DROP the database
  2. db_datareader and db_datawriter is the minimum access that should be given to normal user to do the basic SELECT, UPDATE, INSERT and DELETE operation to the database
db_owner
db_datareader
db_datawriter
  1. Can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server
  2. Normal users should not be a member of this role.
  3. Some applications might require their user account to be a member of this role.
  1. Members of the db_datareader fixed database role can read all data from  all user tables.
  2. The db_datareader role gives implicit access to SELECT against all tables and views in a database.
  1. Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.
  2. The db_datawriter role gives implicit access to INSERT, UPDATE, and DELETE against all tables and views in a database.

Source:

  1. https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15
  2. https://www.mssqltips.com/sqlservertip/1900/understanding-sql-server-fixed-database-roles/

How to Configure MS SQL Server Express to Use Windows Authentication

  1. Create an user account on the computer that act as a server, the username and password must used exactly like the account used in client computer
  2. In SQL Server Management Studio:
    • Expand “Security” -> expand “Logins” -> “New Login
    • Click “General” -> select “Windows authentication” -> click “Search”
    • Type the account name that has been created on server computer, click “Check Names
    • Alternatively you can do this step by clicking “Advanced” button -> “Find Now” -> find the account name in the search results -> click “OK

    • Click “Server Roles” -> check for sysadmin
    • Click “User Mapping” -> choose database -> check for db_datareader and db_datawriter

Note: You do not need to enter the password as SQL Server will ask Windows to validate the user password. (source: https://www.virtual-dba.com/differences-windows-sql-server-authentication/)

How to View the Log of MS SQL Server Express to Check for Login Status

  1. You can choose what type of login activity that you want the SQL Server to log. By default, SQL Server will log the “Failed logins only” activity only. To choose the login activity, right-click at your “Server <instance name>” -> “Properties”. In Server Properties, click “Security” and choose the activity in Login auditing area:
    • None
    • Failed logins only
    • Successful logins only
    • Both failed and successful logins
  2. To view the MS SQL Server log files, expand “Management” -> expand “SQL Server Logs“, click any log date that you want to view:
  3. All the login activities can be viewed in the Log file summary area: