Video Screencast Help

itAnalytics

Created: 14 Mar 2013 | 7 comments

I am having problems with running reports itAnalytics.

and install all components but still I can not get in, and download the program that calls me.

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB

anyone has any solution?

 

Operating Systems:

Comments 7 CommentsJump to latest comment

jre357's picture

Microsoft Server Applications

The authenticated user cannot access the requested cube. Please verify that the authenticated user has proper privileges to the requested cube on the SQL Server Analysis Services instance on which it is hosted, and that the client machine has the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider installed. Additionally check the browser settings for the internet zone this site shows up in and verify that the setting called "Access data sources across domains" under Miscellaneous is set to "Enable" or "Prompt".

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is required for the Office Web Components to communicate with Microsoft SQL Server 2005 AnalysisServices. This is a standard component bundled with recent Microsoft products such as Office 2007 and SQL Server 2005 Management Studio, and is also available from the Microsoft Web site. To download Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, navigate to the section labeled "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" at the following URL: http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

 

Clint's picture

I agree that setting up IT Analytics was a pain and, unfortunately, I didn't document everything I did to get it to work nor really remember what I did first, second, etc.  In my case, my main problem was the fact that the SQL server I was hitting (which someone else set up) didn't have SQL Reporting and Analysis Services installed.  Make sure your SQL server has these components loaded so you don't go round and round like me thinking the problem has to be on your PC.

Clint

jlevicke's picture

Does anyone else have this same issue, I can access the cubes but not the dashboards and not the reports. I get the same error as above when I try and launch any of the reports or the dashboards. The cubes work fine. Also, all systems involved are in the same domain.

Thanks,

-John

Greg2105's picture

I'm having the same problem.  Try editing the ServiceDesk connection under Settings->All Settings->Notification Server->IT Analytics Settings->Connections->Symantec ServiceDesk.

If you seem to be having the same problem as me, you should see "Error occured attempting to add Linked Server. View the Log for more details."  (or just an ASPX error page if not running from the NS/SMP Console server).

Viewing the logs I see reference to "There is no remote user 'sa' mapped to local user '(null)' from the remote server '<linked_servername>'.  

I'm trying to use SQL authentication (the sa account) as required by the documentation. I have also created new SQL logins, given permissions and tried with the new account. It to results in "no remote user 'xxxx' mapped to local user (null)" messages in the logs.   I'm assuming the issue has to do with the mapped local user (null) but not sure where to go from here.

Anyone have any ideas?

RobertBaggitt's picture

When recieving this error:

Microsoft Server Applications

The authenticated user cannot access the requested cube. Please verify that the authenticated user has proper privileges to the requested cube on the SQL Server Analysis Services instance on which it is hosted, and that the client machine has the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider installed. Additionally check the browser settings for the internet zone this site shows up in and verify that the setting called "Access data sources across domains" under Miscellaneous is set to "Enable" or "Prompt".

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is required for the Office Web Components to communicate with Microsoft SQL Server 2005 AnalysisServices. This is a standard component bundled with recent Microsoft products such as Office 2007 and SQL Server 2005 Management Studio, and is also available from the Microsoft Web site. To download Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, navigate to the section labeled "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" at the following URL: http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

Click the link and scroll down to SQLServer2005_ADOMD_x64.msi and download

http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/SQLServer2005_ADOMD_x64.msi

Next download the SQLServer2005_ASOLEDB9_x64.msi

http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/SQLServer2005_ASOLEDB9_x64.msi

 

This should fix the issue.