Problem
=======
ACS reporting does not run normally

"報表處理期間發生錯誤" (An error has occurred during report processing)

"無法與資料來源 'dataSource1' 建立連接" (Cannot create a connection to data source 'dataSource1')

clip_image002


CAUSE
======

1. 您的 Reporting Server OperationsManagerAC 資料庫在兩台不一樣的 SQL Server

2. 您目前 Reporting Server (http://report_server/reports) 上的 "Audit Report\DB_Audit" 連線設定指到一台沒有 Hosting OperationsManagerAC 資料庫的 SQL Server

RESOLUTION
=========

1. 修改 "Audit Report\DB_Audit" 連線設定,讓他只到有 Hosting OperationsManagerAC 資料庫的 SQL Server

步驟如下:

1. 點選 "顯示詳細資料"

clip_image004

2. 點選 "Audit Report\DB_Audit"

clip_image006

3. 修改 "連接字串"

clip_image008