Windows way to Digital Learning……

Archive for the ‘Tips & Tricks’ Category

How to install MS17-010 security update

How to install MS17-010 security update

To install MS17-010 security update, we need to download the corresponding patch from Microsoft update catalog server depending upon operating system.

Windows XP SP3

Open Microsoft Update Catalog Server’s URL then search for KB4012598.

Click on Security Update for Windows XP SP3 (KB4012598) to view update details and language selection, click Download to download the patch for Windows XP SP3.


Click the windowsxp-kb4012598-x86-custom-enu_eceb7d5023bbb23c0dc633e46b9c2f14fa6ee9dd.exe link to begin the download.

Double click the downloaded .exe file to install the patch.

Click Next, Select I Agree then Click Next.

Click Finish to restart.

After system restart. You can verify the patch using below command.

C:\Users\myousufali>wmic qfe get Caption,Description,HotFixID,InstalledOn | findstr /C:”KB4012598″

 

How to change or reset the SA password for MSSQL in Linux

How to change or reset the SA password for MSSQL in Linux

To  reset SA password execute:

First you need to stop  mssql-server  using this command

 sudo systemctl stop myssql-server

sudo /opt/mssql/bin/mssql-conf setup

Setting up Microsoft SQL Server

Enter the new SQL Server system administrator password:

Confirm the new SQL Server system administrator password:

Starting Microsoft SQL Server…

Enabling Microsoft SQL Server to run at boot…

Setup completed successfully.

To change MSSQL SA password

Login to MSSQL by executing these commands.

    cd /opt/mssql-tools/bin/

    ./sqlcmd -S srv01 -U sa 

To change MSSQL sa account password, execute these commands.

EXEC sp_password NULL, 'Mssql@12345','sa'

go

 

mssql-sa-pwd-change-linux

How to Disable SSL 2.0 and SSL 3.0 on Exchange 2013 running on a Windows 2012

How to Disable SSL 2.0 and SSL 3.0 on Exchange 2013 running on a Windows 2012

Resolution:

Open the registry and edit the values. If you don’t find the entries create the entries.

 

To disable SSL 2.0

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Client]
"DisabledByDefault"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Server]
"Enabled"=dword:00000000

To disable SSL 3.0

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Client]
"DisabledByDefault"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server]
"Enabled"=dword:00000000

 

To disable Ciphers:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Ciphers]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Ciphers\RC4 128/128]
"Enabled"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Ciphers\RC4 40/128]
"Enabled"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Ciphers\RC4 56/128]
"Enabled"=dword:00000000

Alternate way to do this save above registry information keys as .reg files then execute on the system.

You can also download from here.

Before executing take the complete registry backup.  You need to restart the server.

Using the http://ssllabs.com/ web site to perform a test against you site. You should see overall Rating A.

 

A Volume Shadow Copy Service operation error has occurred: 0x800423F0

Windows Backup Error: Detailed error: ERROR – A Volume Shadow Copy Service operation error has occurred: (0x800423F0)

vss_error1

Resolution:

In an elevated open powershell: vssadmin list writers

vss_error2

Writer name: ‘FSCVSSWriter’

Writer Id: {68124191-7787-401a-8afa-12d9d7ccc6ee}

Writer Instance Id: {2865b83a-ebb5-4431-8164-a90ff79c59ca}

State: [7] Failed

Last error: Inconsistent shadow copy

Execute Services.msc (To open services windows) and disable or restart Microsoft Forefront Server Protection VSS.

vss_0x800423f0

Restart windows backup, now backup should complete.

How to check the Volume Shadow Copy Service (VSS) provider/writer status

How to check the Volume Shadow Copy Service (VSS) provider/writer status.

To check the VSS provider/writer status.
1. Open a command window. Click Start > Run and type CMD, and then click OK.
2. At the command prompt, type vssadmin list providers, and then press ENTER.
3. Confirm that the list shows Microsoft VSS providers listed as:

  • Microsoft Software Shadow Copy provider 1.0
4. Type vssadmin list writers at the command prompt, and then press ENTER.
5. Confirm that all the VSS writers are showing:
  • State: [1] Stable
  • No error

KB2990170 – MPIO Identifies Different Disks As The Same Disk

KB2990170 – MPIO Identifies Different Disks As The Same Disk

 

Symptoms

The code in Microsoft Windows that converts a hexadecimal device ID to an ASCII string may drop the most significant nibble in each byte if the byte is less than 0×10. (The most significant nibble is 0.) This causes different disks to be identified as the same disk by Multipath I/O (MPIO). At the very least, this may cause problems in mounting affected disks. And architecturally, this could cause data corruption.

Resolution

When you apply this hotfix, the conversion algorithm is fixed. Disks that were masked by this issue before you installed the hotfix may be raw disks that still have to be partitioned and formatted for use. After you apply this hotfix, check in Disk Management or Diskpart for previously hidden disks.

A supported hotfix is available from Microsoft Support.

Query based collection to collect Hyper-V / Vmware Hosts

Query based collection to collect Hyper-V  & Vmware Hosts and Guest Systems.

Host and Guest OS Collection

Host and Guest OS Collections

 

#1 Query based collection to collect all hyper-v  & Vmware hosts using WQL.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName in (“Hyper-V Virtual Machine Management”,VMware Authorization Service”)

#2 Query based collection to collect all hyper-v  & Vmware guests using WQL.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer in (“VMware, Inc.”,”Microsoft Corporation”)

 

 

Tag Cloud