Historical Reports / Crystal Reports user access

Unanswered Question
Dec 4th, 2008
User Badges:

I am running IPCC 5.0.

We have an in-house expert on Crystal, and they would like to create some custom reports for historical reporting purposes.

I want to give them access to the MSDE database, but I do not want them to have admin rights to the IPCC server.

Can someone please give me a few bullet points on how to get this done?


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
mikram Thu, 12/04/2008 - 06:33
User Badges:
  • Bronze, 100 points or more

Are you sure it is MSDE 2000 or SQL 2K installed. You do need admin access to database. We are using Crystal version 11.0 . Which version you are using?

Jonathan Schulenberg Fri, 12/05/2008 - 03:46
User Badges:
  • Super Bronze, 10000 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

I would recommend ordering the UCCX SQL 2000 disc (you get this from Cisco, not MS) and replicating the data off-box. The Crystal resource can work with the data on the other server without any access to the UCCX server. This also has the benefit of whatever queries, views, etc he needs to create not being able to affect call processing.

hauchinango Fri, 12/05/2008 - 05:09
User Badges:

Thank you very much for the info.

We have a large SQL deployment in house, so it may be possible to migrate this off box and use our corporate SQL infrastructure.

When doing this, does it effect anything other than reportings? Is this a difficult process?


This Discussion