Skip to Content
Jul 22, 2020 at 12:17 PM

SAP IDM - Microsoft SQL server database Integeration



I want to do provisioning in MSSQL database. For the same, trying to connect to database and read data. I have followed the below steps:

1. Created a repository type of template: database

2. Created repository for the same

3. Given the details in the repository's constant (JDBC Url - database servername,port, databasename,user, pwd)

4 a. Created a pass (From Custom Pass) and while running, getting the below error:

b. I have also tried to do this via From database Pass and there I am getting below error (in spite of user and password are correct):

"Login failed for user 'trngidm'. ClientConnectionId:f745fe10-babb-49fa-8796-2de866a88cfb"

Please help me to solve this and let me know what am I missing here? And which approach is correct to connect to mssql database?

Thank you in advance for your help!


scyio.png (63.2 kB)