| Event Id | 10003 | | Source | Microsoft SQL 2000 | | Description | The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: CReportSyncTask::ExecTask, 595, Report Sync failed: Error - unable to fetch http://localhost/AppAnalyzer_Reports/ReportTemplateCtrl.aspx?UniqueID=66_1844&DrillDownReport=true. | | Event Information | According to NetIQ :
CAUSE:
The Microsoft Internet Information Server credentials passed to Microsoft SQL Server 2000 and Microsoft Analysis Services do not have sufficient permissions to retrieve data for the scheduled report. Scheduled AppAnalyzer reports require a localhost lookup to generate the report URL.
RESOLUTION:
The following steps will resolve the issue.
Verify the AppAnalyzer Admins and AppAnalyzer Users groups have proper SQL/OLAP
permissions
To do this:
1.Wait for all curent AppAnalyzer Tasks to complete.
2.Stop the AppAnalyzer Server service and the World Wide Web Publishing service via the
Services section of the Windows Control Panel.
3.Open SQL Enterprise Manager.
4.Expand your server, expand the security folder, then select Logons.
5.Delete the \AppAnalyzer Admins, \AppAnalyzer Users, and
\ SQL logons.
6.Open SQL Enterprise Manager.
7.Open SQL Server Query Analyzer.
8.Select the Database (AppAnEx).
9.Type the following SQL query:
Exec isp_add_role_member '\', 'db_owner'
Exec isp_add_role_member '\AppAnalyzer Admins', 'db_owner'
Exec isp_add_role_member '\AppAnalyzer Users', 'db_datareader'
Exec uti_grant_access '\AppAnalyzer Users'
Where is the name of the Domain to include the Service Account and Groups reside and
is the name of the account created for the AppAnalyzer Service to run as.
10.Execute the SQL query by using F5 or the green arrow.
| | Reference Links | Event ID: 10003Of Source ID: Microsoft SQL 2000 |
|
|
