Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Cisco: VOIP

CCM 4.1.3 - Authentication to 'SQL Server and Windows' for authentication from 'Windows Only'

 

 

Cisco voip RSS feed   Index | Next | Previous | View Threaded


humayun.sami at waridtel

May 22, 2008, 5:09 AM

Post #1 of 2 (423 views)
Permalink
CCM 4.1.3 - Authentication to 'SQL Server and Windows' for authentication from 'Windows Only'

Cisco-Voip Members.



I am trying to connect the CDR DB on the client SQL installed on my
machine, but it is not working for CCM only. I have been successful in
connecting the other machines in my IPCC Environment. So I read
somewhere that it's not possible in CCM coz the structure is not the
same as other machines.



Cisco recommends that Call manager not be a member of a domain, it isn't
possible to use flow through authentication to access the SQL Database
server when on a host other than Call manager. Cisco therefore suggests
that SQL Authentication be changed to 'Mixed Mode'. This can be
accomplished by starting SQL Enterprise Manager on the Call manager
Server containing the CDR's right click on the server name and select
properties, select the security tab, and choose 'SQL Server and Windows'
for authentication. Call manager will need to be restarted. Right now
the default installation contains Windows only so after changing to Sql
Server and Windows for authentication with the SQL you will need to
restart the system.



Here if I plan to change my machine Authentication to 'SQL Server and
Windows' for authentication from 'Windows Only', what discrepancies it
will cause if changed.





Regards,

Humayun Sami...


This e-mail is confidential and intended solely for the use of the individual or entity to whom they are addressed. It may also be legally privileged. If you are not the named addressee, you should not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return e-mail. Internet communications cannot be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions.


bills at psu

May 22, 2008, 6:08 AM

Post #2 of 2 (375 views)
Permalink
Re: CCM 4.1.3 - Authentication to 'SQL Server and Windows' for authentication from 'Windows Only' [In reply to]

We have done this and encountered no problems.

You will also need to add a SQL user to the CDR database for remote login.

The main issue, as far as I understand it, with mixed mode is that there
is less security using plain SQL login. Use strong passwords and give
limited access (via firewall/ACL) to the SQL port (1433 I believe) to
reduce the threat.

Humayun Sami/MS IPCC/Dhaka wrote:
> Cisco therefore suggests
> that SQL Authentication be changed to 'Mixed Mode'. This can be
> accomplished by starting SQL Enterprise Manager on the Call manager
> Server containing the CDR’s right click on the server name and select
> properties, select the security tab, and choose 'SQL Server and Windows'
> for authentication. Call manager will need to be restarted. Right now
> the default installation contains Windows only so after changing to Sql
> Server and Windows for authentication with the SQL you will need to
> restart the system.
>
> Here if I plan to change my machine Authentication to 'SQL Server and
> Windows' for authentication from ‘Windows Only’, what discrepancies it
> will cause if changed.

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

Cisco voip RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.