<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>Re: [cisco-voip] Remote access to the CDR SQL Database</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText11803 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Ryan,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>what should I do to give this user access
to the database? In the SQL Enterprise Manager?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Ruben</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> Ryan Ratliff
[mailto:rratliff@cisco.com]<BR><B>Enviado el:</B> vie 11/08/2006
16:42<BR><B>Para:</B> Ruben Montes (EU)<BR><B>CC:</B>
cisco-voip@puck-nether.net<BR><B>Asunto:</B> Re: [cisco-voip] Remote access to
the CDR SQL Database<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>If you need/want to use Windows auth simply create a local user
on <BR>the CM publisher and give that user access to the
database.<BR><BR>-Ryan<BR><BR>On Aug 10, 2006, at 3:43 AM, Ruben Montes ((EU))
wrote:<BR><BR>Hi,<BR><BR>I want to access the CDR sql database with an ODBC
connector to <BR>retrieve the data the billing department needs. I'm using
CCM 4.1(3), <BR>so the authentication method for SQL is Windows mode (the
sa user is <BR>disabled). As Cisco recommends, my CallManager is not in the
domain, <BR>it is in its own workgroup. What should I do to access to
the <BR>database? Should I use the local CCM windows account or what?
Is <BR>there any possibility to do some sort of scheduled job from the
SQL <BR>enteprise manager to export some data (columns) to a remote
machine <BR>out of hours, for example?<BR>What method do you use to export
from CallManager the info the <BR>billing department needs?<BR><BR>Thanks
in
advance,<BR><BR>Ruben<BR>_______________________________________________<BR>cisco-voip
mailing list<BR>cisco-voip@puck.nether.net<BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></FONT></P></DIV>
</BODY>
</HTML>