Service Virtualization

 View Only
  • 1.  Trascation details are not getting logged in DB after deploying into VSE

    Posted Oct 14, 2019 11:57 AM
    Hi Team,

    We are unable to log transaction details into MSSQL DB after deploying the VS into Server. Transaction logging is proper while we execute the same  model through ITR.



    DBJDBCDRIVER : com.microsoft.sqlserver.jdbc.SQLServerDriver

    DBCONNECTION STRING : jdbc:sqlserver://SWNC7R1599:1500;databaseName=LISA_stubs_logging;integratedSecurity=true 


    Thanks,
    Kiran.


  • 2.  RE: Trascation details are not getting logged in DB after deploying into VSE
    Best Answer

    Posted Oct 14, 2019 01:04 PM

    Hi,

     

    I assume the VSE is running on a Windows system?

     

    If it is running on a Linux system then the integrated security cannot work. But even when the VSE is running on Windows, what is the user that runs the VSE process? If it is running with the local systemaccount that will probably not work, only when the service is started with an account trusted by your DB server.  

     

    Cheers,

    Danny

     

    ::DISCLAIMER::

    The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.






  • 3.  RE: Trascation details are not getting logged in DB after deploying into VSE

    Posted Oct 16, 2019 04:54 AM
    Hi Danny,

    Yes, VSE is running on Windows server. 

    After using with the DB server account and removing the integratedSecurity=true it is working as expected. 

    Thanks for your support. 



  • 4.  RE: Trascation details are not getting logged in DB after deploying into VSE

    Posted Oct 17, 2019 02:40 AM
    Hi Suryateja,

    The integratedSecurity=true is mostly used when we have to use windows authentication and not passing user-id and password separately.

    Thanks.



    ------------------------------
    Regards,
    Vaibhav Jain
    Capgemini
    ------------------------------