大网数据广告活动
启动与系统组件

Can't install Reporting Services in System Center Operations Manager

· 52CE 我爱测

Troubleshoot the error, Data Reader account provided is not same, which occurs when installing Reporting Services in System Center Operations Manager.

Applies to:   System Center Operations Manager

Symptoms

When you try to install Reporting Services in System Center Operations Manager, you receive the following error message:

Data Reader account provided is not same as that in the management group.

Cause

This issue occurs because there's misconfiguration of the Data Warehouse Report Deployment Account and Data Warehouse Account Run As profiles, which causes problems with data warehouse workflows. Data Warehouse maintenance and running of reports will fail if the default action account doesn't have the necessary SQL Server permissions.

Resolution

To fix the issue, reconfigure the profiles as follows. You can also reconfigure profiles by using PowerShell automatically.

Step 1: Data Warehouse Report Deployment Account profile

Set the Data Warehouse Report Deployment account to be used for the following classes:

  • Collection Server
  • Data Warehouse Synchronization Server

Step 2: Data Warehouse Account profile

Set the Data Warehouse Action account to be used for the following classes:

  • Collection Server
  • Data Warehouse Synchronization Server
  • Data Set
  • Operations Manager APM Data Transfer Service

After the reconfiguration, you can install Reporting Services successfully by using the Data Warehouse Report Deployment account.

Note: If the issue remains, verify the permissions of the System Center Operations Manager databases (OperationsManager and OperationsManagerDW) are set correctly.

Reconfigure profiles using PowerShell automatically

Tip: Before running the following PowerShell script, we suggest removing all Run As accounts from the Data Warehouse Report Deployment Account and Data Warehouse Account Run As profiles.

function Invoke-TimeStamp
{
    $TimeStamp = (Get-Date).DateTime
    return "$TimeStamp - "
}
Write-Host "`n`n------------------------------------------------------------" -ForegroundColor Green
#Associate Run As Account association in Data Warehouse and Report Deployment Run As Profile.
Write-Output "$(Invoke-TimeStamp)Script started"

Import-Module OperationsManager

#Get the run as profiles
$DWActionAccountProfile = Get-SCOMRunAsProfile -DisplayName "Data Warehouse Account"
$ReportDeploymentProfile = Get-SCOMRunAsProfile -DisplayName "Data Warehouse Report Deployment Account"

#Get the run as accounts
$DWActionAccount = Get-SCOMrunAsAccount -Name "Data Warehouse Action Account"
$DWReportDeploymentAccount = Get-SCOMrunAsAccount -Name "Data Warehouse Report Deployment Account"

#Get all the required classes
$CollectionServerClass = Get-SCOMClass -DisplayName "Collection Server"
$DataSetClass = Get-SCOMClass -DisplayName "Data Set"
$APMClass = Get-SCOMClass -DisplayName "Operations Manager APM Data Transfer Service"
$DWSyncClass = Get-SCOMClass -DisplayName "Data Warehouse Synchronization Server"

#Setting the association
Write-Output "$(Invoke-TimeStamp)Setting the Run As Account Association for Data Warehouse Account Profile"
try
{
    Set-SCOMRunAsProfile -ErrorAction Stop -Action "Add" -Profile $DWActionAccountProfile -Account $DWActionAccount -Class $CollectionServerClass, $DataSetClass, $APMClass, $DWSyncClass
    Write-Output "$(Invoke-TimeStamp)   Completed Successfully!"
}
catch
{
    Write-Output "$(Invoke-TimeStamp)   Unable to set the RunAs accounts, try removing all accounts from inside the RunAs Profile (`"Data Warehouse Account`"), and run the script again.`n"
}
Write-Output "$(Invoke-TimeStamp)Setting the Run As Account Association for Data Warehouse Report Deployment Account Profile"
try
{
    Set-SCOMRunAsProfile -ErrorAction Stop -Action "Add" -Profile $ReportDeploymentProfile -Account $DWReportDeploymentAccount -Class $CollectionServerClass, $DWSyncClass
    Write-Output "$(Invoke-TimeStamp)   Completed Successfully!"
}
catch
{
    Write-Output "$(Invoke-TimeStamp)   Unable to set the RunAs accounts, try removing all accounts from inside the RunAs Profile (`"Data Warehouse Report Deployment Account`"), and run the script again."
}

Write-Output "$(Invoke-TimeStamp)Script ended"
Write-Host '------------------------------------------------------------' -ForegroundColor Green

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/15/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。