When trying to export CDR data from my publisher I'm getting this error: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL server connection. I know this has to do with the SQL server being set for Windows authentication. Would I be causing any harm changing the authentication to "mixed mode" Windows & SQL?
As noted in the article, the change away from mixed mode authentication was made to "ease administration" and reduce the number of passwords users have to remember. Additionally, windows authentication is preferred by Microsoft as more secure than SQL Server authentication.
You may need to disable the Cisco Security Agent running on CallManager in order to make the change (and then re-enable the CSA after the change is made). You may also need to reboot the CallManager server to get the change to take effect.
I've done this a few times - when I did it with CCM running, the system blocked for quite some time. When I first shut down all CCM services and made the change, it was really painless so my suggestion would be to schedule a downtime to make the change.
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...