Service Virtualization

  • 1.  External DB Configuration

    Posted 4 days ago
    Hi Team,

    We have installed CA Devtest in linux server and currently working on external DB configuration for Registry.

    In Devtest manual we found that below configuration is for linux server DB configuration.

    We have recieved DB user name and password to access SQL DB.

    But the user name does not have domain name for it.

    Is it possible to configure username without domain name, Please confirm.

    Thanks in advance!!


    lisadb.internal.enabled=false
    lisadb.pool.common.driverClass=net.sourceforge.jtds.jdbc.Driver
    lisadb.pool.common.url=jdbc:jtds:sqlserver://<DB_IP_ADDR>:<DB_IP_PORT>;instance=MSSQLSERVER;databaseName=devtest;domain=<USER_DOMAIN>;user=<USER_ID>;password=<USER_PASSWORD>;
    lisadb.pool.common.user=<USER_DOMAIN>\<USER_PASSWORD>
    lisadb.pool.common.password_enc=l335e298cc850c4146cf71b3b47afaf025cd9bbda7a40c4ddc13d64c0b6b5ad7521cd630fa379617be582a0


    ------------------------------
    Thanks & Regards,
    Gurukiran
    ------------------------------


  • 2.  RE: External DB Configuration

    Broadcom Employee
    Posted 4 days ago
    Hi,

    You can use the OOTB MSSQL JDBC driver to connect to MS SQL databases. With that driver to connect to the database there's no need to specify a domain.

    ## ==================================================================================
    ## MS SQL Server
    ## ==================================================================================
    ## lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
    ## lisadb.pool.common.url=jdbc:sqlserver://[SERVER]:[PORT];databaseName=[DATABASENAME]
    ## lisadb.pool.common.user=[USER]
    ## lisadb.pool.common.password=[PASSWORD]
    ##

    Danny Saro

    Client Services Consultant

    Broadcom Software


    -------------------------------------------------


    This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.





  • 3.  RE: External DB Configuration

    Posted 3 days ago
    Edited by Vaibhav Jain 3 days ago
    Hi Guru,

    I agree with Danny, you need to use the right set of driver for the configuration without domain.

    Thanks

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



  • 4.  RE: External DB Configuration

    Posted yesterday
    Hi @DannySaro & @Vaibhav Jain,

    Thanks a lot guys, It worked for me.

    Regards,
    Gurukiran​​​


  • 5.  RE: External DB Configuration

    Posted yesterday
    Cool, thanks for the update

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