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

[Ed Leatherman]

Thanks Anthony, I did not know that.. I assumed it was auto-generated
on install. That puts things into perspective.

My apprehension in changing this account is a combination of not
wanting to monkey with a service account unless I have a good reason
to, and the fact that if I am going to have trouble with one of
cisco's products 9/10 times it's UCCX. The password being hard coded
and well-known would certainly change my opinion on this (I now have a
very good reason to change it).



On Fri, Aug 27, 2010 at 4:35 PM, Anthony Holloway
<avholloway+cisco-voip at gmail.com> wrote:
> 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
>
>



-- 
Ed Leatherman