09-23-2009 08:01 AM
I want to set up an ODBC connection to view data from the Campus Manager User Tracking Database. During the installation of LMS the database passwords were randomly generated, how do I find out the CM database username and password to configure the ODBC connection?
I have read some documentation about resetting password to various databases but was unsure if this would have an adverse affect on LMS running?
Thought I'd better seek some advice. Any help would be very much appreciated.
Regards
Tim
Solved! Go to Solution.
09-23-2009 08:20 AM
There's a dbpasswd.pl utility in ${NMSROOT}/bin/, as answered here:
I think this post addresses your DB access quesiton:
09-23-2009 08:20 AM
There's a dbpasswd.pl utility in ${NMSROOT}/bin/, as answered here:
I think this post addresses your DB access quesiton:
09-23-2009 08:28 AM
Correct. You should NOT be using the DBA account (or cwsiSA) in this case for DB access. Instead, follow the steps in the document from the linked thread above to enable direct database access. You will not have to use dbpasswd.pl in that case.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: