- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- SIM 7.2 : SQL login failure after migrating the CM...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2013 04:30 AM
11-15-2013 04:30 AM
Hello.
We recently migrated (not simply joined) our CMS server from AD domain DomA to domain DomB using a quest console. The HP sim service was using DomA\user to start, the service is now using DomB\user, with the same password.
Today, for a reason I ignore the web site was unavailable even if the HP sim service was starting.
In the mxdomainmgr.0.log, there was these error :
Caused by: java.sql.SQLException: Cannot open database "Insight_v50_0_11374566" requested by the login. The login failed.
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot open database "Insight_v50_0_11374566" requested by the login. The login failed.)
The SQL log shows that the CMS is still trying to use DomA\user to connect to the SQL DB despite I changed all the references to the DomA domain in the following files according to a HP white paper I found :
database.admin
database.props
databaseadminupd.tpl
databaseupdate.tpl
globalsettings.props
The HP Sim service is also updated to use DomB\user and starts.
Rebooting the server doesn't solve the issue.
I just added back DomA\user account in the SQL DB access list and HP SIM loads successfully again.
But DomA will be disconnected in a few weeks and the problem will get back.
I searched the files for an occurence of DomA\user but didn't find any.
Is there an other place than the aboves files where I should change the credentials to connect to the SQL DB ?
Or a command I should use to update this ? I gave a look at the MX commands but didn't find one that could help me.
Regards.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2013 09:12 AM
11-15-2013 09:12 AM
SolutionHello.
I finally found the answer in that article :
The file I needed to change was :
"D:\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\deploy\hpsim-ds.xml"
Now the CMS is fully running with the Domb\user account.
Hope it will help.