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

[Ryan Ratliff]

Change it to mixed mode if you need to.   As discussed in the link  
you provided the change was purely to make it easier for admins.

-Ryan

On Nov 15, 2007, at 7:45 AM, Tim Reimers wrote:


Well, I found this:

http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/ 
products_tech_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_tech_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:



By default, CCM’s implementation of SQL Server runs in “Windows”  
authentication mode.
My (internal non-public-facing) webserver with the PHP script on it  
is in one Windows domain, and the CCM is in another
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.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip