[cisco-voip] Connecting to the SQL Server 2000 on Call Manager fromanother domain...

[Matt Slaga (US)]

Most CDR reporting companies will change the SQL server from windows
authentication to mixed mode and connect via the SA account.  It is
supported by Cisco.

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Tim Reimers
Sent: Wednesday, November 14, 2007 4:47 PM
To: Cisco Voip Mailing list
Subject: [cisco-voip] Connecting to the SQL Server 2000 on Call Manager
fromanother domain...

 

 

Here's what I'm trying to do-

 

I'm working on a PHP script that can connect to the SQL server with a
user configured with readonly access to the CDR database, pull out the
CDR info and convert the epoch time to realtime, and put the results
into readable form.

It will also allow the selection of dates and times according to the
form data entered.

 

Unfortunately, I'm running into the problem that:

 

1.	By default, CCM's implementation of SQL Server runs in "Windows"
authentication mode.
2.	My (internal non-public-facing) webserver with the PHP script on
it is in one Windows domain, and the CCM is in another
3.	I cannot do a 'trust' between those two domains without jumping
through some _serious_ hoops to get it both permitted and done.

 

Soo... I'm a little stuck with the process of automating this according
to how someone does a web form, OR just plain automating it entirely and
having a script send out daily custom report(s) of calls.

 

If I could use just SQL Server credentials, it'd probably work fine-but
that won't work.

Using Windows credentials, I get a "user not associated with a trusted
SQL Server" message, which Google reveals to be the "crossing domains"
problem, essentially...

 

 

Does anyone know of any way to connect to the SQL Server db on CCM from
another domain?

 

Thanks, Tim




-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071114/27c8f6cc/attachment.html