Video Screencast Help

IT Analytics configuration

Created: 03 Oct 2012 | 2 comments

It was suggested I check out IT Analytics, so I was following this to try to get started

I didn't get very far, though, because I couldn't get the analysis server to verify its connection.  I have a main CMS server and a separate SQL server, tried both, no dice.

I put a ticket in with Symantec, and they said it's because I didn't set up analysis and reporting services on the SQL server, and I should do that.

Is this part of the Symantec documentation somewhere on exactly what I should be doing?  Symantec said I should work with our DB admin, we are a school district and there's no expert here I can go to for that.  I'm googling around but don't want to do the wrong thing and risk anything with the SQL server.

I'm running CMS 7.1 SP2 and MS SQL server 2008 r2 64 bit.

Thanks for any advice.

Comments 2 CommentsJump to latest comment

andykn101's picture

If you haven't got SQL skills available and don't want to risk anything with the live SQL serve you should try and set up a test server. VMware workstation may be the answer, so you can get confidence adding Analysis and Reporting Services to a SQL sever.

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.

Sally5432's picture

I installed reporting and analysis, I didn't realize the link above had a how to with requirements which sort of pointed me in the right direction.

Both Reporting and Analysis services are started, and the reporting server URL from the Reporting Services Config Manager now loads for me on my client test workstation.  However, putting server name in the CMS console and clicking verify connection is now producing "Analysis Server 'servername' does not exist."

So I missed something some where.  Will post back if I figure it out.

Don't forget to mark posts as helpful if they are, and mark answers as solutions.