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

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

CDR DB access

CM version 4.3

I am trying to connect a billing server to callmanager CDR table. I have set the security on the DB to mixed mode. Created an account on CM with access to the CDR table but when I try and create a system dsn on billing server I get the error "login failed for user "cdraccess", not trusted. I have done this many time with no issues has anything changed in cm 4.3? or have I missed a step?

thanks

2 REPLIES
Super Bronze

Re: CDR DB access

Hi

When you create the DSN you select either 'With NT authentication...' or 'With SQL Authentication...'

If you have created an account in SQL on the CCM server, you'll be using SQL Authentication and the account info you set up.

If you have granted access to the SQL database to a local Windows account on the CCM server, then you'd use NT Authentication in your DSN.

Since you have enabled mixed-mode, you should be using SQL auth.

The 'not trusted' error suggests you've picked NT authentication on your DSN.

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Re: CDR DB access

on the DSN I selected SQL authentication,

I have also tried logging in locally to query analyzer using the sa login and the account I created and both do not work, double checked the DB and it is set for mixed mode

165
Views
0
Helpful
2
Replies