[cisco-voip] CCM 4.1.3 - Authentication to 'SQL Server and Windows' for authentication from 'Windows Only'

[Bill Simon]

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.