14 Replies Latest reply on Jan 15, 2021 3:03 PM by Kathy Wang

    user_powercenter_repo still trying to log in to old server after switching to new server

    Kathy Wang New Member

      Hi all experts,

       

      Recently we moved repository server to a new one. we only have one node in this domain. We used infasetup.bat updategatewaynode and successfully updated the node. On informatica admin console, all connections are updated.

       

      Now we are receiving complains from DBA that the user user_powercenter_repo (for powercenter repository service) still trying to log into the old sql server.

       

      failure message: login failed for user 'user_powercenter_repo': failed to open the explicitly specified database. [CLIENT 0.0.0.0]

       

      Anyone can guide me to troubleshoot my configuration or settings/steps  that I missed while updating gatewaynode ?

       

      Thanks.

       

      Regards,

      Kathy