2 Replies Latest reply on Jan 26, 2020 7:04 PM by Gwendolyn Jones

    PowerCenter repository service (V 10.4) - database connectivity

    Sandosh Adhimoolam New Member

      Hello,

       

      I'm new to the admin task, and i'm trying to create PowerCenter Repository Service and ended up with database connectivity error. Tried some options, but no luck.

       

      Please help me to resolve this error.

       

      Informatica Version: 10.4

      Repository Database: SQL Server 2016

      Informatica Server OS: Windows Server 2016

       

      options tried:

      1. created DSN with "SQL Native Client 11", and "SQL Server"

      2. converted to "Trusted Connection" under Advanced properties

      3. Changed the connection string to JDBC URL , servername:port@databasename & servername@databasename

       

      Note: model repository & Data Integration service were created & enabled successfully.

       

      attached the error screenshot.