CDR DB access

Unanswered Question
Nov 10th, 2008
User Badges:

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


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Aaron Harrison Mon, 11/10/2008 - 04:35
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

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...

mymite060708 Mon, 11/10/2008 - 04:42
User Badges:

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


Actions

This Discussion