I want to execute SQL queries in CA ITPAM using windows authentication.
Has anyone done that before or if anyone has any insight on this, please share your findings.
Check the doc here:
Database Server Login Parameters - CA Process Automation - 4.3 - CA Technologies Documentation
I read the document you shared and tried to execute the process but I am getting the error that the application is not able to connect to the database.
I am trying to use the following URL:
"jdbc:sqlserver://" + hostname + "\\" + MSSQLSERVER + ":" + 1433 + ";DatabaseName=" + ServerDetails + ";integratedSecurity=true"
This is the error i am getting after executing the process.
Could not connect to the database; - url=jdbc:sqlserver://hostname\MSSQLSERVER:1433;DatabaseName=ServerDetails - Login failed for user 'username'.
Here is some additional information on integratedSecurity that might help:
Enable Windows Integrated Security for the MSSQL Server JDBC Module - CA Process Automation - 4.3 - CA Technologies Docu…
Retrieving data ...