My SQL Server password expired and I had to reset it to a new password. Now I am unable to start my Informatica service because it comes up with below error. How should I change my Password? Any help much appreciated!!
Cannot start node due to the error: [[RSVCSHARED_00014] Internal error. The Repository Capability ['Persistence'] failed to initialize for the following reason: '[PERSISTENCEAPI_0307] [DBPERSISTER_0009] Failed to connect to the database with JDBC connection string 'jdbc:informatica:sqlserver://My-PC:1433;DatabaseName=INFA_REPO;SnapshotSerializable=true' as user 'INF_USER.' Verify that the connection string and user name are valid. This was caused by [informatica][SQLServer JDBC Driver][SQLServer]Login failed for user 'INF_USER'.'. Contact Informatica Global Customer Support.]
Resolved it by resetting my SQL server password to the old one. I had tough time recollecting it. But this is weird, I can never change my SQL Server password because somewhere during Informatica installation I have used it. I am still curious to know where the password would have been saved for the informatica service to make the node start. Any pointers will be much appreciated...
The password is encrypted and stored in "<install_dir>/isp/config/nodemeta.xml" in 9.1
You can update the password on the domain using the following command:
./infasetup.sh updateGatewayNode -dp <database password>>
The infasetup.sh is available in the server folder of the install. Pls note that you should shutdown the node before you update the domain password.