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
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.
Retrieving data ...