Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

SQL CDR access from another machine

According to Cisco recommendations, I have my Callmanagers in a workgroup. I wish to access the CDR database on the publisher from a workstation which is a member of an Active Directory domain. Callmanager, by default, has SQL configured as Windows Authentication only.

What is Cisco's accepted practice for being able to connect to the CDR Database from a workstation not in that workgroup?

Does one make callmanager a member server of a domain? Does one convert SQL back to SQL & Windows authentication? Is there a better alternate way?

Cisco Employee

Re: SQL CDR access from another machine

Either suggestion you have provoded will work. We do not recomend that the CCM server be placed in a domain as the domain policies can affect the CCM server, even if you THINK you are not appyig them to the CCM. The better solution is to convert SQL back to SQL & Windows authentication. SQL authentication was disabled as a security measure, just be aware.


New Member

Re: SQL CDR access from another machine

We are trying to do the same thing, but on our IPCC server, and the database admin can't gain access. I can select the option for SQL server and WIndows, but it won't save the changes. Is there another setting that needs to be enabled for that?

New Member

Re: SQL CDR access from another machine

It's the simple things in life that get you.

I figured out what my issue was, CSA wouldn't allow me to switch the authentication, and then once I got that set, I had to use the servername\CRSSQL as the server to attach to.

In case anyone was interested.