[cisco-voip] Remote access to the CDR SQL Database

[Ruben Montes (EU)]

Hi Ryan,
 
what should I do to give this user access to the database? In the SQL Enterprise Manager?
 
Regards,
 
Ruben

________________________________

De: Ryan Ratliff [mailto:rratliff at cisco.com]
Enviado el: vie 11/08/2006 16:42
Para: Ruben Montes (EU)
CC: cisco-voip at puck-nether.net
Asunto: Re: [cisco-voip] Remote access to the CDR SQL Database



If you need/want to use Windows auth simply create a local user on 
the CM publisher and give that user access to the database.

-Ryan

On Aug 10, 2006, at 3:43 AM, Ruben Montes ((EU)) wrote:

Hi,

I want to access the CDR sql database with an ODBC connector to 
retrieve the data the billing department needs. I'm using CCM 4.1(3), 
so the authentication method for SQL is Windows mode (the sa user is 
disabled). As Cisco recommends, my CallManager is not in the domain, 
it is in its own workgroup. What should I do to access to the 
database? Should I use the local CCM windows account or what? Is 
there any possibility to do some sort of scheduled job from the SQL 
enteprise manager to export some data (columns)  to a remote machine 
out of hours, for example?
What method do you use to export from CallManager the info the 
billing department needs?

Thanks in advance,

Ruben
_______________________________________________
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/20060811/fccfb6ad/attachment.html