Windows way to Digital Learning……

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

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

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.

 

sql-on-linux

Now Microsoft SQL Server supports on Linux platforms.

I have tested on Redhat, CentOS and Oracle Linux.

Here we will see step by step guide to install SQL server on Linux.

Supported platforms

Platform

Supported version(s)

Get

Red Hat Enterprise Linux

7.3

Get RHEL 7.3

SUSE Linux Enterprise Server

v12 SP2

Get SLES v12 SP2

Ubuntu

16.04 and 16.10

Get Ubuntu 16.04

Docker Engine

1.8+

Get Docker

Prerequisites

  • You need at least 3.25 GB of memory to run SQL Server on Linux.

 

Install SQL Server

  • Login to root user using putty.

su - root

  • We will download and install SQL server repositories by using following commands.

# curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo
> /etc/yum.repos.d/mssql-server.repo

# curl https://packages.microsoft.com/config/rhel/7/prod.repo
> /etc/yum.repos.d/msprod.repo

 

sql-on-linux_curl

  • Verify .repo files under /etc/yum.repos.d/ directory

sql-on-linux_repos

  • To install SQL Server and MSSQL Tools package, run the following commands
# yum install -y mssql-server mssql-tools

sql-on-linux_1

sql-on-linux_2

sql-on-linux_3

  • Run the configuration script to accept license terms and set SA password
# cd /opt/mssql/bin/
# sudo ./mssql-config setup

 

sql-on-linux_4

  • To verify the mssql-server service is running
# systemctl status mssql-server

sql-on-linux_5

  • To open tcp-1433 port on system firewall in order to allow external clients to communicate with the database server.
# firewall-cmd --add-port=1433/tcp --permanent
# firewall-cmd --reload

 

sql-on-linux_6

  • Testing SQL Server
# cd /opt/mssql-tool/bin/
# ./sqlcmd -S srv01 -U SA

 

 

Upgrade SQL Server

  • To upgrade the mssql-server package on Linux, execute the following command
# yum update mssql-server

Uninstall SQL Server

  • To uninstall or remove the mssql-server package on Linux, execute the following command

# yum remove mssql-server  
(Remove or delete mssql-server package)

# rm -rf /var/opt/mssql/
(Remove or delete database files)

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.

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

 Microsoft Free E-Books 

Introducing Windows Server 2016

  • Introducing Windows Server 2016
    John McCabe

  • Data Science with Microsoft SQL Server 2016
    Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok

  • Microsoft Azure Essentials: Fundamentals of Azure, Second Edition
    Michael S. Collier and Robin E. Shahan

  • Configuring Microsoft SharePoint Hybrid Capabilities
    Jeremy Taylor, Neil Hodgkinson, and Manas Biswas

  • Windows 10 IT Pro Essentials Support Secrets
    Ed Bott

  • Introducing Microsoft Power BI
    Alberto Ferrari and Marco Russo

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

  • Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
    Stacia Varga, Denny Cherry, and Joseph D’Antoni

  • Microsoft Platform and Tools for Mobile App Development
    Cesar de la Torre and Simon Calvert

  • Microsoft Azure Essentials Migrating SQL Server Databases to Azure
    Carl Rabeler

  • Planning and Preparing for Microsoft SharePoint Hybrid
    Jeremy Taylor

  • Windows 10 IT Pro Essentials: Top 10 Tools
    Ed Bott

  • Creating Mobile Apps with Xamarin.Forms
    Charles Petzold

  • Deploying Windows 10: Automating deployment by using System Center Configuration Manager
    Andre Della Monica, Russ Rimmerman, Alessandro Cesarini, and Victor Silveira

  • Introducing Windows 10 for IT Professionals, Technical Overview
    Ed Bott

Free E-Book: Microsoft Press : Enterprise Cloud Strategy

  • Enterprise Cloud Strategy
    Barry Briggs and Eduardo Kassner

Courtesy: Microsoft Press
Find more training eBooks & books at The Microsoft Press Store.

Tag Cloud