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!