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

[Tim Reimers]

Well, I found this:
 
http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_t
ech_note09186a00801d71c5.shtml
 
See section 3, the note at the bottom:
 
"Note: When third party applications need to access the Cisco
CallManager database, SQL authentication might be required, but this is
not supported by Cisco."

 
I hope Cisco has simply changed their mind and not updated this
document...
 
Cisco discussing the reason for the move to Windows auth only on 4.0
http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_t
ech_note09186a00801f9f33.shtml

I wish I could open a TAC case and find out..but I don't have Smartnet
directly -- I'm under a shared support contract and my vendor would
certainly charge for finding out.
 
 
Tim Reimers 
Assistant Network Administrator 
Asheville City Schools 
Desk- 828-350-6195 Mobile-828-545-3104
fax- 828-255-5454 
  

Most days, there are several fires burning at once. Some days, what's
burning is your fire extinguisher.
To err is human; to truly screw it up requires the root password.

 

 

________________________________

From: Matt Slaga (US) [mailto:Matt.Slaga at us.didata.com] 
Sent: Wednesday, November 14, 2007 8:54 PM
To: Tim Reimers; Cisco Voip Mailing list
Subject: RE: [cisco-voip] Connecting to the SQL Server 2000 on Call
Manager fromanother domain...



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/20071115/1c16a141/attachment-0001.html