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

[Tim Reimers]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071114/39f83a14/attachment.html