Posts

Showing posts from 2020

How to edit and delete channels on LG smart TV

Image
This post describes how to edit and delete channels from the TV guide for an LG smart TV. Resolution On my LG TV (webOS UK6950PLB), the steps I took to do this were: Open the LG TV guide Press the Programme Manager icon in the top right: Press Edit All Programmes On the Edit All Programmes screen, select the channels to hide on the right Press the Skip/Restore icon in the top right Select Skip from the drop down: Once a channel has been set to Skip, it no longer appears in the TV guide. Can't see Programme Manager? If your LG TV has a Channel Manager with an Edit All Channels screen, you may be able to access a Delete/Restore function.  This can be seen in the Set Up Over-the-Air Channels section of this article:  https://www.tomsguide.com/uk/us/lg-tv-settings-guide,review-4701.html Related Posts -  LG TV This app will now restart to free up more memory -  LG TV Clear All Browsing History Data -  LG TV turn off Quick Start in settings -  LG TV move or delet...

Get-WinEvent show or filter errors from event log only PowerShell

Image
This post describes how you can filter the results from the Get-WinEvent PowerShell command so only certain entry types are shown e.g. error entries only. Resolution Use -FilterHashTable and Level='2'.  You can also specify other levels to show different entry types. Get-WinEvent -MaxEvents 1 -FilterHashTable @{LogName='System';Level='2'} | Format-Table -Wrap

Get-EventLog Message truncated - Show full event log message PowerShell

Image
This post describes how to get the full event log message using the Get-EventLog PowerShell command which, by default, will truncate the message: Resolution Use Format-Table -Wrap: Get-EventLog Application -Newest 1 | Format-Table -Wrap Use -ExpandProperty: Get-EventLog Application -Newest 1 | Select -ExpandProperty Message

Windows Hard Drive Volume Format Partition File System exFAT Missing

Image
This post describes why the exFAT option is sometimes missing from the File system drop down when formatting a hard disk drive volume in Windows using Disk Management. Cause This issue can occur when the size of the volume you are formatting is less than 32GB, which is the maximum partition size limit using the FAT or FAT32 file system format on Windows. If you format a volume below 4GB, you will see FAT and FAT32 in the file system drop down, but not exFAT, as per the screenshot above. If you format a volume above 4GB but below 32GB, you will see FAT32 in the file system drop down, but not exFAT: Resolution If you format a volume above 32GB, you will see exFAT in the file system drop down: Alternatively, you can use format.exe in a command prompt to format the volume as exFAT.

PowerShell Get-Volume exFAT File System Type Unknown

Image
This post describes an alternative way to get a volume's file system type when it is formatted as exFAT and PowerShell Get-Volume returns the data as Unknown. Here is an exFAT volume in Disk Management: PowerShell Get-Volume returns FileSystemType Unknown  If I run the PowerShell command Get-Volume on Windows Server 2019 or Windows 10, the FileSystemType for the exFAT volume is returned as Unknown: Resolution To resolve the issue, you can get the data using the Win32_Volume class: Get-CimInstance Win32_Volume|SELECT DriveLetter, Label, FileSystem

Camtasia cursor effect to simulate and indicate a mouse click

Image
This post describes how to add a Camtasia cursor effect to simulate and indicate a mouse click by making the mouse size change, similar to the effect seen in the Camtasia Tutorials. The effect can easily be created by using a simple animation. 1. Change the default cursor size to 150% across the entire clip 2. Add a Custom animation where you want to indicate a mouse click.  Shorten the animation length to about 0.1 seconds. 3. Set the cursor size to 100% after the animation 4. Add a second Custom animation and place this directly after the first animation 5. Set the cursor size back to 150% after the second animation 6. Fine tune the position of the animations if required.  The middle of the animation should be lined up with where you want to simulate a mouse click. Double click To simulate a double click, simply copy and paste the two animations above and put them all next to each other. Quickly apply elsewhere Once created, you can easily use the cursor effect in other part...

Camtasia Behaviors, Cursor, Audio and Visual Effects empty with no effects showing

Image
This post describes how to fix a problem in which Camtasia Behaviors, Cursor Effects, Audio Effects and Visual Affects are empty with no effects showing: This happened after I first installed Camtasia 2020. Resolution The resolution turned out to be quite easy.  I simply closed Camtasia then re-opened it.  The Behaviors, Cursor Effects, Audio Effects and Visual Affects now appeared as expected: Related Posts -  Camtasia cursor effect to simulate and indicate a mouse click -  Open camproj file in Camtasia 2020

A file that is required cannot be installed because the cabinet file has an invalid digital signature. This may indicate that the cabinet file is corrupt.

Image
This post describes how to fix the error: A file that is required cannot be installed because the cabinet file has an invalid digital signature. This may indicate that the cabinet file is corrupt. Cause This can occur when certificates from the cabinet file's digital signature certificate trust chain are missing and cannot be validated.  This can happen when you're running an installer in an environment that's not connected to the Internet and is therefore unable to update the trusted certificate authorities automatically. Resolution Right click the cabinet file, go to the Digital Signatures tab, press Details, then View Certificate and check the Certification Path.  This shows the certificates required to complete the trust chain. Next, download and install any certificates that are missing from the trust chain. Related Posts .NET Framework has not been installed because a certificate chain could not be built to a trusted root authority An update is available that enables ...

The request failed with HTTP status 401: Unauthorized

Image
This page describes how to fix the error: Connection Failed. The request failed with HTTP status 401: Unauthorized. Cause This can occur when you try to establish a HTTP connection to an IIS server but the Windows Authentication Role Service has not bee installed. It can also occur if the IIS server requires a client certificate and this hasn't been provided by the client. Resolution Add the Windows Authentication Role Service to IIS: After Windows Authentication has installed, ensure the required Providers have been added e.g. Negotiate and NTLM.

Open camproj file in Camtasia 2020

Image
 This post describes how to open a .camproj file in Camtasia 2020. I was previously using Camtasia Studio 8, which saves projects as a .camproj file type. Camtasia 2020 saves projects as a .tscproj file type and cannot open .camproj files. Resolution Camtasia 2019 can open .camproj files and convert them to the new .tscproj format, which can then be opened in Camtasia 2020. Download Camtasia 2019 Camtasia 2019 can be downloaded here: https://www.techsmith.com/download/oldversions Open in Camtasia 2020 When you open the converted .tscproj file in Camtasia 2020, you get prompted to convert it again: You may need to fix some annotations:  For example, one of my annotations looked very squashed after the conversion: Related Posts -  Camtasia Behaviors, Cursor, Audio and Visual Effects empty with no effects showing -  Camtasia cursor effect to simulate and indicate a mouse click

The WS-Management service cannot process the request. The service is configured to not accept any remote shell requests.

Image
This post describes how to fix the error: The WS-Management service cannot process the request. The service is configured to not accept any remote shell requests. For more information, see the about_Remote_Troubleshooting Help topic. Cause This error can occur when the policy setting 'Allow Remote Shell Access' is disabled: If this policy is set to 'disabled', new remote shell connections are rejected by the server. The recommendation from Microsoft is to only disable this policy setting if you don't need PowerShell Remoting. Resolution To resolve the issue, change the 'Allow Remote Shell Access' policy setting to 'Enabled'. Video Link: The WS-Management service cannot process the request. The service is configured to not accept any remote shell requests. Related Posts -  The WinRM client cannot process the request. The authentication mechanism requested by the client is not supported...

Interactive view hide / expand collapse control in HTML without JavaScript

This post describes how to create an interactive view/hide or expand/collapse control in HTML without JavaScript. The HTML to create this control is as follows: < details >      < summary > Show details... </ summary >      < p > Here are the details! </ p > </ details > By default, this will start collapsed / hidden: Details... Here are the details! You can add the "open" attribute to start the control in a visible / expanded state: < details   open >      < summary > Show details... </ summary >      < p > Here are the details! </ p > </ details > Details... Here are the details! Related Posts -  Remove border from details summary element in CSS

Remove border from details summary element in CSS

Image
 This post describes how to remove the border from the summary element inside a details element in CSS. Create the control Create this control using the following HTML: < details >      < summary > Show more... </ summary >      < p > Here are the details. </ p > </ details > You can use this HTML to create interactive expand-and-collapse controls without any JavaScript.  Show more... Here are the details. Remove the border To remove the border, use the following CSS on the summary element details >   summary  {       outline :  none ; } Show more... Here are the details. Add a cursor pointer You can also change the cursor to a pointer to indicate to the user that they can interact with the control. details >   summary  { ...

Error 577: Windows cannot verify the digital signature for this file

Image
This post describes how to fix: Windows could not start the Windows Defender Antivirus service on Local Computer. Error 577: Windows cannot verify the digital signature for this file. A recent hardware or software change might have installed a file that is signed incorrectly or damaged, or that might be malicious software from an unknown source. Cause This error can occur when you try to start the Windows Defender Antivirus Service and Windows Defender has been turned off in group policy. Resolution Turn Windows Defender on in Group Policy.  For more information, see Related Posts. Related Posts -  Your Virus & threat protection is managed by your organization

Your Virus & threat protection is managed by your organization

Image
This post describes how to enable Windows Defender when the following is shown: Your Virus & threat protection is managed by your organization. Cause This message is shown when Windows Defender is turned off in group policy: Resolution Disable the 'Turn off Windows Defender Antivirus' group policy setting then run gpupdate in a command window. You can verify Windows Defender is now enabled by checking the value of the DisableAntiSpyware key is 0 in the registry. HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows Defender\DisableAntiSpyware Virus & threat protection will now say: Threat service has stopped. Restart it now. Press Restart now and Windows Defender should now be enabled: Related Posts Error 577: Windows cannot verify the digital signature for this file

Document SQL Server 2019 and Azure SQL

Image
If you're looking to document SQL Server 2019 or Azure SQL then download the latest release of XIA Configuration which includes the following new functionality: SQL Server 2019 and Azure SQL XIA Configuration now supports the scanning and documenting of SQL Server 2019 and Azure SQL . Backup Exec Support for scanning and documenting Backup Exec 20.x and 21 has been added to XIA Configuration. Dynamic Scans from CSV or SQL You can now search a CSV file or SQL database for items to scan and add to XIA Configuration. Find out more about XIA Configuration Download a free 30-day trial

Add Chapters to break up YouTube videos into sections

Image
This post describes how to add Chapters to break up YouTube videos into sections. To add chapters to a YouTube video, you simply need to edit the video and add timestamps to the video description like this: 0:00 Introduction 0:27 Chapter 1 1:13 Chapter 2 3:30 End credits Once added, simple save the video, then view it on YouTube to see the chapter markers in the progress scrubbing bar and the chapter name in the video control area. As of 10th February 2021, this feature now also works for embedded YouTube videos.

The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb', schema 'dbo' (Error 229)

Image
This post describes how to fix the error: MSX enlist failed for JobServer An exception occurred while executing a Transact-SQL statement or batch. The enlist operation failed (reason: SQLServerAgent Error: The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229).) (Microsoft SQL Server, Error: 22026) Cause This error can occur when the target server machine account does not have sufficient privileges on the master server. Resolution Check the server roles of the target server machine account on the master server. On my test environment, I resolved the issue by assigning the account the sysadmin server role: Related Posts The enlist operation failed (SQLServerAgent: Unable to connect to MSX) (Error: 22026) The target server cannot establish an encrypted connection to the master server

The target server cannot establish an encrypted connection to the master server (Error: 22026)

Image
This post describes how to fix the error: MSX enlist failed for JobServer. An exception occurred while executing a Transact-SQL statement or batch. The enlist operation failed (reason: SQLServerAgentError: The target server cannot establish an encrypted connection to the master server) (Microsoft SQL Server, Error: 22026) Cause This error can occur if the MsxEncrypyChannelOptions registry subkey is not set correctly on the target server. Resolution Go to the registry on the target server and modify the value of the registry subkey. The possible values are defined here: https://docs.microsoft.com/en-us/sql/ssms/agent/set-encryption-options-on-target-servers?view=sql-server-ver15 For my test environment, I set it to 0, which disables the encryption. Related Posts The enlist operation failed (SQLServerAgent: Unable to connect to MSX) (Error: 22026) The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb',...

The enlist operation failed (SQLServerAgent: Unable to connect to MSX) (Error: 22026)

Image
This post describes how to fix the error: MSX enlist failed for JobServer. An exception occurred while executing a Transact-SQL statement or batch. The enlist operation failed (reason SQLServerAgent Error: Unable to connect to MSX.) (Microsoft SQL Server, Error: 22026) Cause This error can occur when setting up Multi Server Administration > Make this a Master...  Check the log file on the master server (by default located here: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log) 2020-07-21 11:59:19.82 Logon       Login failed for user 'TEST2019\SQL2017-2K19-1$'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.131.227] The target server machine account (in this case 'TEST2019\SQL2017-2K19-1$') does not have permission to login on the master server. Resolution This error can be resolved by adding the target server machine account as a log...

Database cannot be opened. It is in the middle of a restore. (Error 927)

Image
This post describes how to fix the error: Database cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927) Cause This error can occur when you try to configure mirroring using the Configure Database Mirroring Security Wizard. The endpoints are created successfully: However, when you try to Start Mirroring: The error occurs. Resolution To resolve the error, I had to start mirroring in SQL directly. I set the partner to the Principal network address on the mirror SQL instance: ALTER DATABASE AdventureWorksLT2019  SET PARTNER = 'TCP://SQL2019-2K19-1.test2019.net:5022' I then set the partner to the Mirror network address on the principal SQL instance: ALTER DATABASE   AdventureWorksLT2019   SET PARTNER = 'TCP://SQL2019-2K19-1.test2019.net:5023' And set the witness to the Witness network address on the principal SQL instance: ALTER DATABASE   AdventureWorksLT2...