We are building a reporting application that needs to pull records and information from the CDR DB on Call Manager 4.3. Can this be accessed remotley using SQL statements? So far we have had no luck using query analyzer remotely (not logged directly into the CCM server via RDP).
By default, the SQL Server is set up to only allow trusted connections.. and since the machine is not a member of the domain, only the local admin on the CCM box can access the database. You can however change SQL Server to use mixed mode authentication, then create a user and use SQL authentication for a remote login. When you do that, make sure you first disable all CCM services (meaning you need a maintenance window as you'll have a CCM downtime) as CCM starts acting up if you pull out the SQL server from under it (chaning the authentication mode requires a restart). You could also just change the mode, then schedule a server reboot at night.. that should be the least problematic.
if you install ipcx you need to change it to mixed mode, so it is supported.
but depending on the connection method/driver from your application, you might be able to leave it to windows authentication mode, and create a windows account (with minimal rights) and give it privileges to the cdr tables
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...