Posts

Manage Non-Domain Server from Domain Client using RSAT

Manage Non-Domain Server from domain Client RSAT -  Remote Server Administration Tools Sample Names used below: - Non-domain fully qualified server name: `MyServerName.Local` - Local admin user for login: `\\MyServerName.Local\Administrator`   1. Install or Add RSAT to the Client PC running Pro versions Windows 10 / 11.   - Download Link for older version and install instructions: https://www.microsoft.com/en-us/download/details.aspx?id=45520.  - Please pay attention to the Installation Section as no download is necessary for versions after Windows 10 October 2018 Update.  - List of RSAT tools available via Features on Demand:  https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/features-on-demand-non-language-fod#remote-server-administration-tools-rsat  - List of RSAT dependencies: https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/features-on-demand-non-language-fod#remote-server-administration-tools-rs...

Fix for "The secure channel between the local computer and the domain is broken."

The secure channel between the local computer and the domain  is broken.   PS C:\> Test-ComputerSecureChannel -verbose   VERBOSE: Performing the operation "Test-ComputerSecureChannel" on target "MyLocalPCName". False VERBOSE: The secure channel between the local computer and the domain MyDomain is broken.   PS C:\> Test-ComputerSecureChannel -verbose -repair -credential MyDomain\MyDomainAdmin   VERBOSE: Performing the operation "Test-ComputerSecureChannel" on target "MyLocalPCName". True VERBOSE: The secure channel between the local computer and the domain MyDomain was successfully repaired.     #powershell #ps #domain #ad #script

Excel - Column Number to Column Name Converter and Column Name to Column Number Converter

Image
Formula for converting Excel Column Number to Column Name (Column Number specified in B1): =SUBSTITUTE(ADDRESS(2, B1, 4), "2", "")   Formula for converting Excel Column Name to Column Number (Column Name specified in B2): =COLUMN(INDIRECT(B2&"1"))  

Open Settings Application from cmd in WIndows

start ms-settings:

Word for Windows with Merge Fields and problem during Print Preview

Word for Windows with Merge Fields and problem during Print Preview ISSUE: Document merges normally and shows all the fields. When CTRL-P is pressed for Print Preview, the footer fields are shown as Merge Fields (not replaced). FIX:  Edit Word Template Select all footer fields Press CTRL-F11 to lock them   This seems to be fixing the issue.   Word Shortcuts  

Create Application specific password for Google

Create Application specific password for Google Starting 2022-05-30 Google is no longer supporting less secure apps. Please use below steps to turn on App password for your google account. Login to your Google email at https://gmail.google.com . Navigate to https://myaccount.google.com/signinoptions/two-step-verification . Enable " two step verification ". Create application-specific password via https://security.google.com/settings/security/apppasswords . Save a 16 digits App password that can be used by specific app using your Google email address.      

Stop MS Edge from running in background when Edge is closed

Image
Stop MS Edge from running in background when Edge is closed In MS Edge Navigate to: edge://settings/?search=startup Uncheck " Startup boost " Uncheck " Continue running background extensions and apps when Microsoft Edge is closed "