Service Virtualization

  • 1.  Using SQL Server with Windows Authentication for DevTest

    Posted Feb 25, 2019 09:08 AM

    I am trying to connect  mssql database from sql execution jdbc step using windows authentication, i am using sqljdbc4-4.0 jdbv driver in lib shared folder and have sqljdbc_auth.dll in lib/native folder, also the dll file in present in the java/lib folder of x64 since we have 64bit java installed, when trying to connect through my workstation is shows connecting to database and then the workstation closes abruptly without any error message or even a warniing or error message in any logs, kindly help me with this 

     

    Thanks and Regards

    Akanksha Gupta



  • 2.  Re: Using SQL Server with Windows Authentication for DevTest

    Broadcom Employee
    Posted Feb 25, 2019 10:16 AM


  • 3.  Re: Using SQL Server with Windows Authentication for DevTest
    Best Answer

    Broadcom Employee
    Posted Feb 25, 2019 02:46 PM

    Could you please show me the connection string you are using? 

    for example:  

    url=jdbc:sqlserver://DBHost:1433;databaseName=ED801DB;integratedSecurity=true



  • 4.  Re: Using SQL Server with Windows Authentication for DevTest

    Posted Feb 26, 2019 04:10 AM

    Hi Shiney

     

    Thanks for your reply i am using the  same connecting string as suggested by you, In my C drive the sqljdbc_auth.dll file was placed in the java/ lib folder instead of java/bin hence the error i changed it and now the issue is resolved and is working fine thanks for your help

     

    Regards

    Akanksha Gupta