[cisco-voip] Exporting CCX historical reports to SQL Server 08 Express

[Anthony Holloway]

Why do you loathe to change the CRSAdministrator password?  That's common
security practice, as this account password is the same on every install.
 And given that it's a local administrator, you should have changed this
long ago.

Here is the CRSAdministrator password that is defaulted on every UCCX
install since forever:  NwY.t9g(f'L9[3C

Anthony Holloway

On Fri, Aug 27, 2010 at 8:41 AM, Ed Leatherman <ealeatherman at gmail.com>wrote:

> Hi folks,
>
> Looking for some advice on exporting UCCX data to an external server
> .. hopefully someone else has been down this road before.
>
> I have UCCX 7 w/SQL Server 2000 installed, and I have a SQL 2008
> Express server ("data warehouse") that I would like to export
> historical reporting data. We have multiple customers that would like
> to do some custom reporting development - would much rather they
> thrashed around on a separate system than on the production contact
> center.
>
> I have successfully exported the relevant tables and stored procs
> manually, and used this to build a DTS package so that this operation
> can be scheduled to run nightly. Running the package manually also
> works fine. The developers can hit the data warehouse server and do
> what they need to do just fine. At this time though, I have to
> manually push the data over to it every morning.
>
> I am having trouble figuring out how to get this to work as a
> scheduled job, as the SQL Agent service runs as the "CRSAdministrator"
> account, and when it runs my DTS package it tries to use this account
> to access the data warehouse server. Since I don't know the password
> for CRSAdministrator, I can't set up a duplicate account on the data
> warehouse for this to work. Am I missing something? I can change the
> account SQL Agent runs as, but this will also change the account the
> other CRS jobs are run as, which I'm going to assume is a big no-no.
>
> The only option I see is to use the admin tool to change the password
> for CRSAdministrator.. something I am loathe to do if there is any
> other better options. Has anyone else used an external reporting
> server, and if so how did you schedule nightly updates?
>
> Have a great weekend!
>
> --
> Ed Leatherman
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100827/9684e07e/attachment.html>