External DB Configuration

[Gurukiran Karkera]

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

[Danny Saro]

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.

[Vaibhav Jain]

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

[Gurukiran Karkera]

Hi @Danny Saro & @Vaibhav Jain,

Thanks a lot guys, It worked for me.

Regards,
Gurukiran​​​

[Vaibhav Jain]

Cool, thanks for the update

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