SIM 7.2 : SQL login failure after migrating the CMS to a new AD domain

[OlivierV]

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.

[OlivierV · Accepted solution]

Hello.

I finally found the answer in that article :

http://h20565.www2.hp.com/portal/site/hpsc/template.PAGE/public/psi/mostViewedDisplay/?javax.portlet.begCacheTok=com.vignette.cachetoken&javax.portlet.endCacheTok=com.vignette.cachetoken&javax.portlet.prp_efb5c0793523e51970c8fa22b053ce01=wsrp-navigationalState%3DdocId%253Demr_na-c03585371-2%257CdocLocale%253Den_US&javax.portlet.tpst=efb5c0793523e51970c8fa22b053ce01&sp4ts.oid=489496&ac.admitted=138...

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.