DPM 2012 Reporting Issue (ID : 220)

After upgrading from SCDPM 2012 SP1 to SCDPM 2012 R2, I hit the issue when I tried to configure the Reporting to be send out periodically in the Report Module of SCDPM 2012 R2.

The steps taken was the following :

• Launch the Reporting Services Manager (in my example is SQL 2008 R2, since it’s upgraded gradually from SCDPM 2012 SP1 to SCDPM 2012 R2)
• Ensure to the correct database that I’m pointing to  (e.g. MSDPM2012)
• Navigate to E-Mail Settings.
• Key in the valid Sender Address and SMTP Server.
• Click Apply

• Launch the SCDPM 2012 R2 – Reporting
• Configure the schedule reporting with emails, tested with no issues.keywords : SCDPM 2012, DPM cannot enable e-mail subscription for reports unless SMTP details are configured in the remote SQL Server Reporting Service Installation. SMTP details need to be configured manually when an existing SQL Server is chosen to be used for DPM during DPM setup.  Please enter the SMTP server name, SMTP port number and SMTP From address manually in the SQL Server Reporting Services configuration File.

Configuration file path : c:\Program Files\Microsoft DPM\SQL\MSRS10.MSDPM2010\Reporting Services\ReportServer\RSReportServer.config

The SMTP Server  details on the SMTP Servers tab in the Options dialog enables only DPM alert notifications. For more details, see DPM Help (ID : 220)

SCDPM Report error, Systems Center Data Protection Manager Report Error, cannot configure email distribution in DPM report

Systems Center Data Protection Manager 2012 R2 Keeps Crashing – ID:917

Have managed to upgrade from SCDPM 2012 SP1 to SCDPM 2012 R2.  The DPM agents and the Protection Groups are still intact.

However, when I tried to edit or remove the Protection Group, the SCDPM 2012 R2 Administrator console keeps crashing and restart the DPM Administrator Console

After finding out, the issue is NOT the Data Protection Manager, but it’s the SQL that is storing the DPM Database.  The SCDPM 2012 R2 has also been patched with UR6, however it still crash whenever I tried to edit or remove the Data Protection.

Therefore these are the steps taken.

• Take a backup of the DPM Database
• Right-click on the SQL Management Studio and select “Run as administrator”

• Once the SQL Management launched, right-click on the DPMDB and select “New Query”
• Copy and paste the following SQL Script

update tbl_IM_ProtectedGroup SET IMCatalogXML = replace(cast(IMCatalogXML as nvarchar(max)), '<AllowedBackupType>FullBackup', '<AllowedBackupType>Regular') from tbl_IM_ProtectedGroup where IMCatalogXML like '%<AllowedBackupType>FullBackup%'

• Click Execute and it should show the results.  The example is as above picture. 
• Launch the SCDPM 2012 R2 Administrator Console, and it’s successful can edit or remove the Protection Group.

keywords : SCDPM 2012 R2, upgrade of SCDPM 2010 to SCDPM 2012 R2, Error : 917, Systems Center Data Protection keeps crashing after upgrade in place, in-place, inplace, Restarting Administrator Console.

"Cannot connect to WMI provider. You do not have permission or the server is unreachable" in SQL Server

 

When trying to open MS SQL Server Configuration Manager, a dialog may appear..

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]

Cause :
An issue with the compiled SQL Configuration Manager GUI’s communication with WMI.

A work around is as follow :

Open a command prompt (elevated, run as administrator)

Then Navigate to your SQL version’s shared directory (cd <version path>):

 

SQL 2008	C:\Program Files (x86)\Microsoft SQL Server\90\Shared\
SQL 2008 R2	C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012	C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014	C:\Program Files (x86)\Microsoft SQL Server\120\Shared\

After that execute the following command :
mofcomp sqlmgmproviderxpsp2up.mof

After that reboot the server to get all related services to start.

keywords : Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]; SQL,

How to Access or Connect to DPM 2010 SQL

Current Operating System : Windows 2008 R2
Data Protection Version : DPM 2010

Here’s a simple step that I access to my DPM 2010 SQL.  I need to do a backup.

• <Right-Click> on the SQL Server Management Studio
• Select Run as administrator

• In the Server Name column, key in as
  • .\msdpm2010

or

• dpmservername\msdpm2010
  replace the dpmservername with your server that the DPM is installed on.

• Expand the Databases, then navigate to DPMDB

• <Right-Click> on the DPMDB – select Tasks – then select Back Up …

• Click OK to backup the database
• Default path is : C:\Program Files\Microsoft DPM\SQL\MSSQL10DPM\MSSQL\Backup

keywords : SQL, DPM 2010, SCDPM 2010, Data Protection 2010, SQL for DPM 2010, open SQL for DPM 2010

How to Remove Azure Account (Cached) using PowerShell

Recently I’ve done quite a lot of testing using various accounts to Azure.  All the commands are executed in the PowerShell ISE (Run ISE are Administrator).

The PowerShell should have the Azure Commands in it already.  If not, can download from here.

Select the Install from the Command-line tools

When I tried to Get-AzureAccount, it displayed more than one account and subscriptions

I need to remove the other subscriptions.  Therefore I perform as follow :

Execute the command as below :

• Get-AzureAccount | format-table id

Once displayed, I execute to remove the account using

• Remove-AzureAccount account-name

Note : Just replace the account-name with the account that needs to be deleted.

Another way is to remove all the accounts then re-add it back. 

To do this execute it as below to remove all the accounts :

• Get-AzureAccount | ForEach-Object {Remove-AzureAccount $_.ID -Force}

To add the account that I’m working on, use :

• Add-AzureAccount

 

keys : add azure account, remove azure account in cache, Azure powershell command line, command-line, azure subscription, AzureSubscription, get-azureaccount, remove-azureaccount

Azure–Token Error when execute from Powershell

I was doing the following :

• Connect to a Azure from a Computer A
• Execute the connection from PowerShell and connecting to Azure
• Everything was ok.

Then I went to another location.  Executing the same process by connecting to Azure through the PowerShell.  I had no issue when executing the Add-AzureAccount but when I check I tried to get the subscription, I had the error as below :

After some finding, it seemed the token in the second location has expired.  Therefore I did the following :

• The User I login is Administrator, therefore I go to :

C:\Users\Administrator\AppsData\Roaming\Windows Azure Powershell

Note : Change only the value in the PINK, with whatever credential you use to login to the PC.

• Delete all the content in the directory

• Proceed back to PowerShell and Add-AzureAccount
• Then execute the Get-Subscription will display with no issue.

keywords : failed to refresh token, no service namespace, the server returned an error (400), AadAuthenticationFailedExecption, Bad Request

DPM Reporting – An error has occurred during report processing

I hit an issue on launching the DPM reporting.  The DPM is functioning well except the reporting.  It’s the issue of the SQL Reporting settings.

It stated as :

An error has occurred during report processing. (rsProcessingAborted).
Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)
Invalid object name ‘vw_DPM_Replica’.

Steps taken to resolve :

• Launch the Reporting Services Configuration Manager in the DPM

• Select the Report Manager URL on the left panel
• Click on the URL on the right panel

• Double-click on the DPMReporterDataSource

• The Connection string is missing.
• Minimize this screen

• Create a file call dbtest.udl on the desktop (it’s a build in Windows)
• Double click on it.

• Once the Data Link Properties launch, Select the server name (using the drop down)
• Use the Windows NT integrated security for the credential
• Select the database (using the drop down)
• Click Test Connection

• Click OK once it’s successful

• Right-click on the dbtest.udl and open with notepad

• Copy the text from “Intergrated ….. “till the end of the line

• Maximize the DPMReporterDataSource
• Paste the copied text into the Connection string.
• Click on Test Connection (may request to key in password again)
• Once successful, click Apply.

Launch the DPM reporting with no issue occurred.

keyword : DPM, SQL, SRSS, Reporting Services, rsErrorExecutingCommand, rsProcessingAborted, dataset, query execution failed, invalid object name