12-19-2004 12:55 PM - edited 03-13-2019 07:24 AM
Hi,
I have a CCM 3.2 SpH version..I installed CDR.
It worked fine before but now i cannot access to the CDR ...I've got this error message from the insertCDR.txt file.
....Error code 18456 [failed to connect to
datasource] login failed for user cisco CCMCDR....
Any comments
Thanks
12-19-2004 09:48 PM
I am not sure if this is the fix, but it won't hurt your system
1) Open SQL Enterprise Manager
2) Go to Security ->Logins
3) Look for the account
4) Right click on it -> Properties -> Database access
5) Put a check on CDR and click on "public" and "db_owner"
6) Click on Ok to close the screen
7) Now in Enterprise Manager, go to databases
8) Click on CDR -> Users
9) Right click on the user *CCMCDR* -> Properties -> Put a check on db_owner
10) Follow the same steps from #8 for all cisco* or ccm* users.
12-20-2004 04:09 AM
Well you can try what hinho suggested and you could also test the system dsn which cdr uses to connect ,please check that Dsn and which autentication is this user configured for (windows nt or sql ) and also check this data source.
Hope this helps
Aman
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide