Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

ITA Analytics report error

Created: 31 Jan 2012 • Updated: 14 Feb 2012 | 11 comments
sandys's picture
This issue has been solved. See solution.

Hi I have attached screen shot for the following error.

first the enviorment is

NS 7.1 SP 2 installed on windows 2K8 R2

SQL installed on other machine( SEP and IT analytics database on the same server)

my query is when i am going to NS 7.1 and see the ITA reports on the dashboard.

I got follwing error. Even if OLEDB is installed on the client machine from where i am accessing the NS.

solution needed on this URGENTLY...

Comments 11 CommentsJump to latest comment

mclemson's picture

ITA may not be compatible with SP2.  I've heard of a few environments with this issue, but wasn't involved in resolving it.

Have you checked these KBs?

http://www.symantec.com/docs/HOWTO42165
http://www.symantec.com/docs/TECH162039
http://www.symantec.com/docs/TECH174986
http://www.symantec.com/docs/TECH175120

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

sandys's picture

Hello mclemson , thanks for the reply .

Here is my environment.

I have configured SMP Notification Server > IT Analytics Settings>>Configuration>>Stored Credentials

As i have tried both Stored Credentials and also Windows Integrated Authentication.

But when using stored credentials ..When i go to Reports>>>Dashboard>>  and click on any of the SEP dashboard in the right pane of the window. i get following error

http status 401 unauthorised...

2nd option Windows Integrated Authentication. used but my client is not ready to change the trust this computer for delegation to any server  and other detail steps..mention in TECH 175120

As i have searched a lot on this and this issue is getin delayed. a lot.

I need the workaround on first option i.e. on Stored credentials..

reply awaiting earlier

 

Thanks & Best Regards,

Sandy S

STS (SMP 7.1)

sandys's picture

Now the issue is resolved. after digging my head...

yeah...angry

Thanks & Best Regards,

Sandy S

STS (SMP 7.1)

rajeshm_81's picture

Thanks Sandy great job you have finally digged your head and got the solution. can u share what u have did to resolve the issue.....................

 

sandys's picture

hi rajesh nothing much done . only the SMP hosting server setting is changed to following setting in AD and also if the IIS running account is domain account then that accoun also needs to be set as below settings. And setspn utility is not required to run on the SMP and SQL hosting server. thats done... 

Trust this computer for delegation to any service(Kerberos only) smiley

Thanks & Best Regards,

Sandy S

STS (SMP 7.1)

SOLUTION
mclemson's picture

So it sounds like the solution from the 4th KB in my reply (http://www.symantec.com/docs/TECH175120) resolved your issue by changing the Kerberos setting as described.  Glad I could help!

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

andykn101's picture

from Option 2.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

sandys's picture

ya only the  2 steps worked in my case.. it also depends on the environement. sometimes it is also not required 

Thanks & Best Regards,

Sandy S

STS (SMP 7.1)

andykn101's picture

I've got two separate IT Analytics systems where I can browse the cubes but get the "cannot access" message on the dashboards and reports. Both have seperate SQL Servers and use Stored Credentials. I've tried trusting the NS for delegation on one site to no effect.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

sandys's picture

if ur using iis as domain accnt that needs to trusted for delegation...and use as WINDOWS INTEGRATED AUTHENTICATION then try it.

Thanks & Best Regards,

Sandy S

STS (SMP 7.1)

andykn101's picture

I have tried Windows Integrated Authentication and that does work. But Stored Credentials (Altiris Service Account) should work too.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.