BugZero | Veeam BugID kb2977 - AlwaysOn Availability Groups cannot be selected wh...

Veeam - Defect ID: kb2977

AlwaysOn Availability Groups cannot be selected while restoring a SQL database to Microsoft SQL Server 2017 after installation of CU15

Veeam - Defect ID: kb2977

AlwaysOn Availability Groups cannot be selected while restoring a SQL database to Microsoft SQL Server 2017 after installation of CU15

Last updated on August 13th, 2020

BugZero Risk Score
9.7 High

Overall: 9.7

Severity: 10.0

Community: 8.3

What is the BugZero Risk Score?

Veeam Integration

Learn more about where this data comes from

Veeam Integration

Learn more

BugZero Plan

Streamline upgrades with automated vendor bug scrubs

BugZero Plan

Learn more

BugZero Prevent

Wish you caught this bug sooner? Get proactive today.

BugZero Prevent

Learn more

Bug Details

Description

Challenge

You try to restore a SQL database to Microsoft SQL Server 2017 with CU15 that supports AlwaysOn Availability Groups, but you are not able to select an availability group at the "Specify AlwaysON Restore Options" step.

Cause

ServerNetworkProtocolProperty is missing in CU15 for SQL Server 2017 VMI class. This class is used during the restore process. In SQL Explorer log files, you can see the following record: Failed to resolve TCP/IP port. Invalid class Missing class will lead to restore issues if the following is true: - SQL server is running on non-default (1433) port. - SQL Server Browser service is not running.

Solution

On the SQL Server, run the following command to recompile MOF files for the WMI SQL Classes: mofcomp %programfiles(x86)%\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof

Change history

2020-08-13 Added: 12.1, 12.3.2, 6.1, 12.2, 12.3, 9.5, 9.0, 10, 12.3.1, 7.0, 13, 5.0, 11, 6.5, 12, 8.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12, 12.3.2, 12.1, 9.0, 12.3, 9.5, 11, 12.2, 8.0, 7.0, 5.0, 6.1, 13, 12.3.1, 10, 6.5

2020-08-13 Removed: ALL

2020-08-13 Added: 13, 9.5, 12.3.1, 12, 8.0, 10, 7.0, 12.3.2, 9.0, 6.1, 12.3, 12.1, 12.2, 6.5, 11, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 5.0, 10, 9.0, 7.0, 12.1, 12.3.2, 11, 6.1, 12, 13, 9.5, 6.5, 12.2, 12.3.1, 12.3, 8.0

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 12, 12.3, 6.1, 9.5, 8.0, 7.0, 12.1, 12.3.2, 13, 10, 12.2, 6.5, 11, 5.0, 12.3.1

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 6.5, 12.3.2, 10, 6.1, 8.0, 12.3, 5.0, 13, 12.1, 12.3.1, 12, 12.2, 11, 9.0, 9.5

2020-08-13 Removed: ALL

2020-08-13 Added: 12.2, 12.1, 9.5, 12, 12.3.2, 8.0, 11, 10, 7.0, 5.0, 12.3, 12.3.1, 6.5, 6.1, 13, 9.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.2, 13, 12.3.1, 7.0, 5.0, 10, 12.2, 9.0, 12.3, 8.0, 6.1, 11, 12, 6.5, 12.1, 9.5

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 12.3.1, 9.5, 13, 10, 5.0, 12.3, 7.0, 6.5, 8.0, 12, 6.1, 12.2, 12.3.2, 11, 12.1

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 9.5, 7.0, 11, 12, 5.0, 12.1, 6.5, 12.2, 10, 9.0, 12.3.2, 6.1, 12.3, 12.3.1, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 11, 12, 9.0, 5.0, 12.3.2, 10, 12.3.1, 8.0, 12.3, 9.5, 12.1, 6.5, 13, 12.2, 6.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 8.0, 13, 12.3.2, 12, 6.1, 9.5, 10, 12.3.1, 12.2, 11, 9.0, 7.0, 12.3, 6.5, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 9.5, 7.0, 6.1, 12.3.1, 5.0, 12.3.2, 10, 12.3, 8.0, 11, 6.5, 12.1, 12, 9.0, 12.2, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 6.1, 12.3, 12.3.1, 8.0, 12.1, 9.0, 12.2, 13, 10, 12, 7.0, 5.0, 9.5, 6.5, 11, 12.3.2

2020-08-13 Removed: ALL

2020-08-13 Added: 11, 12.1, 9.5, 9.0, 7.0, 6.5, 12.3, 12, 12.3.1, 5.0, 13, 12.2, 10, 8.0, 6.1, 12.3.2

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 10, 9.0, 6.1, 7.0, 12.2, 12.3.2, 6.5, 12.3, 8.0, 12.3.1, 9.5, 11, 12, 13, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 6.5, 10, 9.0, 12.3.1, 12.1, 12.3.2, 6.1, 7.0, 5.0, 13, 9.5, 12.2, 12.3, 12, 11, 8.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3, 13, 12.3.1, 12, 9.0, 9.5, 10, 7.0, 6.1, 12.2, 5.0, 11, 12.1, 8.0, 12.3.2, 6.5

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.2, 9.5, 5.0, 6.1, 13, 10, 12.3.1, 12.2, 8.0, 11, 12.3, 9.0, 12.1, 12, 6.5, 7.0

2020-08-13 Removed: ALL

2020-08-13 Added: 6.5, 8.0, 12.3.2, 6.1, 13, 12.1, 11, 7.0, 12, 10, 9.5, 9.0, 12.3.1, 5.0, 12.3, 12.2

2020-08-13 Removed: ALL

2020-08-13 Added: 6.1, 9.5, 12.3.1, 9.0, 12.2, 12, 12.3.2, 7.0, 11, 6.5, 5.0, 12.1, 13, 12.3, 8.0, 10

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 12, 10, 7.0, 12.3, 12.1, 9.5, 8.0, 6.5, 12.3.2, 12.3.1, 13, 12.2, 6.1, 5.0, 11

2020-08-13 Removed: ALL

2020-08-13 Added: 10, 9.5, 11, 5.0, 6.1, 12.3.1, 12.3, 7.0, 12.2, 12.1, 6.5, 9.0, 8.0, 12, 13, 12.3.2

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 12.3.1, 12.3.2, 13, 12.3, 9.0, 5.0, 12.2, 6.1, 10, 12, 12.1, 9.5, 8.0, 6.5, 11

2020-08-13 Removed: ALL

2020-08-13 Added: 9.5, 7.0, 6.5, 12.3.2, 5.0, 12, 12.3.1, 12.3, 12.1, 13, 9.0, 10, 6.1, 8.0, 12.2, 11

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3, 6.5, 12.3.1, 12, 5.0, 12.1, 6.1, 10, 7.0, 8.0, 11, 9.0, 13, 12.2, 12.3.2, 9.5

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 12.3, 8.0, 9.0, 9.5, 6.5, 11, 7.0, 12.3.2, 12.3.1, 6.1, 10, 5.0, 12, 12.2, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.1, 12, 11, 6.5, 6.1, 12.1, 12.3, 13, 12.3.2, 8.0, 7.0, 9.5, 5.0, 9.0, 12.2, 10

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3, 9.0, 6.5, 12.1, 8.0, 13, 9.5, 5.0, 12.2, 12, 11, 10, 7.0, 6.1, 12.3.2, 12.3.1

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 12.1, 12, 9.5, 11, 12.3.2, 12.2, 9.0, 10, 12.3, 12.3.1, 13, 7.0, 6.5, 6.1, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 10, 9.0, 9.5, 12.3, 12.3.2, 12.1, 7.0, 12.3.1, 13, 8.0, 5.0, 12, 6.5, 12.2, 6.1, 11

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 11, 7.0, 12, 10, 9.5, 6.5, 8.0, 6.1, 12.2, 12.3.1, 5.0, 9.0, 13, 12.3, 12.3.2

2020-08-13 Removed: ALL

2020-08-13 Added: 11, 13, 5.0, 12.1, 12, 10, 9.5, 9.0, 8.0, 12.2, 6.5, 12.3.1, 6.1, 7.0, 12.3.2, 12.3

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 6.1, 10, 12.3.2, 6.5, 12.3, 13, 12.3.1, 12, 9.5, 12.1, 8.0, 7.0, 12.2, 11, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.2, 12, 12.2, 12.3, 12.3.1, 6.5, 12.1, 7.0, 8.0, 11, 6.1, 10, 9.5, 9.0, 13, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 9.5, 12.1, 12.3.1, 13, 12, 8.0, 6.5, 11, 9.0, 6.1, 5.0, 7.0, 12.3.2, 10, 12.3, 12.2

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 12.2, 12.3, 9.5, 7.0, 12.3.1, 5.0, 11, 12, 6.5, 12.3.2, 12.1, 8.0, 10, 13, 6.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.1, 6.1, 11, 12.3.2, 9.0, 12.3, 7.0, 13, 12.1, 8.0, 6.5, 5.0, 12, 10, 9.5, 12.2

2020-08-13 Removed: ALL

2020-08-13 Added: 9.5, 9.0, 8.0, 12.3.2, 11, 6.1, 12, 7.0, 12.1, 13, 12.3, 6.5, 12.2, 10, 12.3.1, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12, 9.0, 13, 8.0, 12.2, 12.1, 12.3.1, 10, 6.5, 11, 6.1, 5.0, 7.0, 12.3.2, 9.5, 12.3

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.2, 9.0, 7.0, 12.2, 12, 12.3.1, 13, 11, 6.5, 6.1, 12.1, 9.5, 5.0, 10, 8.0, 12.3

2020-08-13 Removed: ALL

2020-08-13 Added: 12, 9.5, 12.2, 6.1, 12.1, 11, 12.3.1, 10, 12.3, 8.0, 7.0, 9.0, 13, 12.3.2, 5.0, 6.5

2020-08-13 Removed: ALL

2020-08-13 Added: 12, 12.1, 12.3.1, 8.0, 7.0, 6.5, 10, 11, 12.3.2, 12.2, 5.0, 9.5, 13, 9.0, 12.3, 6.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.1, 12.1, 6.5, 12.3.2, 12.2, 11, 9.5, 9.0, 13, 10, 12, 6.1, 5.0, 7.0, 12.3, 8.0

2020-08-13 Removed: ALL

2020-08-13 Added: 6.1, 5.0, 9.0, 12.3, 7.0, 6.5, 12.3.1, 11, 8.0, 12, 12.1, 9.5, 10, 12.2, 12.3.2, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 6.5, 12, 7.0, 6.1, 12.2, 5.0, 9.0, 12.3.2, 12.3.1, 12.3, 11, 10, 9.5, 12.1, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 6.1, 12.2, 7.0, 12.3.2, 10, 9.0, 5.0, 13, 12.1, 12.3.1, 9.5, 8.0, 12.3, 11, 6.5, 12

2020-08-13 Removed: ALL

2020-08-13 Added: 11, 9.0, 7.0, 9.5, 12.3.2, 6.5, 10, 8.0, 12.2, 12.1, 13, 12.3.1, 12.3, 12, 6.1, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 6.5, 12.3.2, 8.0, 6.1, 12.1, 12.3.1, 10, 9.5, 12, 11, 7.0, 13, 12.3, 12.2, 5.0, 9.0

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 5.0, 12.2, 8.0, 6.5, 13, 6.1, 12.3.2, 11, 12.3.1, 12, 9.0, 10, 9.5, 12.3, 12.1

2020-08-13 Removed: ALL

2020-08-13 Added: 13, 12.3.2, 9.0, 12.3, 6.1, 9.5, 8.0, 12, 7.0, 12.2, 6.5, 5.0, 12.3.1, 10, 11, 12.1

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 12, 12.3.2, 6.5, 12.1, 5.0, 13, 11, 7.0, 12.3, 10, 8.0, 9.5, 6.1, 12.2, 12.3.1

2020-08-13 Removed: ALL

2020-08-13 Added: 11, 13, 12.3.2, 9.0, 8.0, 6.1, 9.5, 12, 6.5, 7.0, 12.1, 12.2, 5.0, 12.3, 10, 12.3.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 12.3, 5.0, 12, 11, 6.5, 6.1, 12.3.2, 12.2, 9.5, 10, 12.3.1, 8.0, 13, 7.0, 9.0

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 9.5, 7.0, 5.0, 6.1, 12.3.1, 12.2, 6.5, 9.0, 11, 8.0, 13, 12.3, 10, 12.3.2, 12

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 9.0, 13, 12.1, 12, 12.3.2, 11, 9.5, 10, 6.5, 6.1, 12.3, 5.0, 8.0, 12.3.1, 12.2

2020-08-13 Removed: ALL

2020-08-13 Added: 13, 12.3.1, 11, 10, 6.1, 6.5, 9.0, 9.5, 12.3, 7.0, 12.1, 5.0, 12.3.2, 8.0, 12.2, 12

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3.1, 12.3.2, 11, 9.5, 10, 7.0, 6.5, 12, 9.0, 6.1, 5.0, 12.1, 12.2, 8.0, 12.3, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 6.5, 6.1, 5.0, 8.0, 7.0, 10, 9.0, 12.3, 12.2, 12.3.2, 11, 12, 12.3.1, 9.5, 13, 12.1

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 6.1, 7.0, 5.0, 10, 6.5, 12.3.2, 12, 12.3, 12.1, 12.2, 12.3.1, 13, 11, 9.0, 9.5

2020-08-13 Removed: ALL

2020-08-13 Added: 5.0, 8.0, 12.3.2, 11, 6.1, 13, 10, 12.3.1, 12, 9.5, 9.0, 7.0, 6.5, 12.2, 12.3, 12.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.3, 9.0, 10, 12.3.1, 6.5, 11, 9.5, 7.0, 12.3.2, 5.0, 13, 12.2, 8.0, 12.1, 6.1, 12

2020-08-13 Removed: ALL

2020-08-13 Added: 9.0, 10, 12.3.1, 12, 6.1, 12.3, 5.0, 9.5, 12.3.2, 8.0, 13, 12.1, 12.2, 11, 7.0, 6.5

2020-08-13 Removed: ALL

2020-08-13 Added: 6.5, 12, 12.3, 12.3.1, 9.0, 12.2, 7.0, 9.5, 8.0, 13, 11, 5.0, 10, 12.1, 12.3.2, 6.1

2020-08-13 Removed: ALL

2020-08-13 Added: 12.1, 8.0, 11, 6.1, 13, 12.3.2, 12, 12.2, 9.5, 9.0, 6.5, 7.0, 10, 5.0, 12.3.1, 12.3

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 12.3.2, 12.2, 9.5, 11, 12.3, 12, 5.0, 12.3.1, 10, 9.0, 6.5, 6.1, 7.0, 12.1, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 7.0, 11, 5.0, 12.3.2, 8.0, 6.1, 12.3.1, 13, 9.0, 12.2, 12.3, 12.1, 6.5, 9.5, 12, 10

2020-08-13 Removed: ALL

2020-08-13 Added: 13, 7.0, 8.0, 12.2, 11, 9.0, 6.5, 6.1, 12, 9.5, 12.1, 12.3.1, 5.0, 10, 12.3, 12.3.2

2020-08-13 Removed: ALL

2020-08-13 Added: 10, 9.5, 7.0, 12.1, 12.2, 6.5, 12, 12.3, 6.1, 13, 12.3.1, 8.0, 11, 12.3.2, 9.0, 5.0

2020-08-13 Removed: ALL

2020-08-13 Added: 5.0, 9.0, 12, 9.5, 7.0, 12.3.2, 12.2, 12.3, 10, 8.0, 12.1, 6.5, 11, 12.3.1, 6.1, 13

2020-08-13 Removed: ALL

2020-08-13 Added: 8.0, 6.1, 11, 10, 9.5, 12.3.2, 12, 9.0, 7.0, 6.5, 12.1, 12.2, 5.0, 12.3.1, 12.3, 13

2020-08-13 Removed: ALL

2020-08-13 Added: ALL

Relevant Products

Click on a version to see all relevant bugs

Affected versions:8.0, 12.3.2, 12.2, 9.5, 11, 12.3, 12, 5.0, 12.3.1, 10, 9.0, 6.5, 6.1, 7.0, 12.1, 13

Fixed versions: No known fixed versions

Relevant Products

Click on a version to see all relevant bugs

Affected versions:8.0, 12.3.2, 12.2, 9.5, 11, 12.3, 12, 5.0, 12.3.1, 10, 9.0, 6.5, 6.1, 7.0, 12.1, 13

Fixed versions: No known fixed versions

Top Veeam Defects

9.9Defect ID: kb4820
Support Statement — Exchange Web Services (EWS) Deprecation
9.7Defect ID: kb4796
The HTTP request was forbidden with client authentication scheme
9.7Defect ID: kb4867
Email item data export from EWS failed
9.6Defect ID: kb2669
Restored Linux Machine Fails to Boot
9.6Defect ID: kb4814
Restore to AWS EC2 Fails with: "ClientError: Unknown OS / Missing OS files" or "FirstBootFailure"

Ready to prevent the next vendor outage?

Get a demo

Veeam - Defect ID: kb2977

AlwaysOn Availability Groups cannot be selected while restoring a SQL database to Microsoft SQL Server 2017 after installation of CU15

Veeam - Defect ID: kb2977

AlwaysOn Availability Groups cannot be selected while restoring a SQL database to Microsoft SQL Server 2017 after installation of CU15

Last updated on August 13th, 2020

BugZero Risk Score9.7 High

Bug Details

Challenge

Cause

Solution

Top Veeam Defects

Ready to prevent the next vendor outage?

Links

BugZero Risk Score
9.7 High