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