IT Process Automation

  • Private Community

  • 1.  How to execute SQL queries using Windows Authentication in ITPAM

    Posted Jan 13, 2017 02:12 AM

    Hi All,

     

    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. 

     

    Thanks, 

    Vidit Goel



  • 2.  Re: How to execute SQL queries using Windows Authentication in ITPAM
    Best Answer

    Broadcom Employee
    Posted Jan 13, 2017 03:44 PM

    Check the doc here:

     

    Database Server Login Parameters - CA Process Automation - 4.3 - CA Technologies Documentation 

     

    ;integratedSecurity=true

     



  • 3.  Re: How to execute SQL queries using Windows Authentication in ITPAM

    Posted Jan 16, 2017 06:42 AM

    Hi Andy,

     

    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'.

     

    Thanks,

    Vidit Goel



  • 4.  Re: How to execute SQL queries using Windows Authentication in ITPAM

    Broadcom Employee
    Posted Jan 18, 2017 05:16 PM

    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…