Connection Issue with the JDBC Source

Hi,
I am trying to establish a connection with a JDBC Source in tenant, but I am encountering the following error during the test connection:

Thanks,
Rohit

Hi @rohitmisal45 ,

This looks to be a permission issue with the service account that you are using to connect to the jdbc source. Please check the permissions with the concerned team and confirm the service account have necessary read permissions to the table that you are connecting to.

Thanks

jdbc:sqlserver://URL:PortNo;DatabaseName=DBNAME;encrypt=false
(Update JDBC:SQLServer name to above url as per your database type.)

Try setting the above url in your connection settings (by adding encrypt=false at the end ) and check if that works.

@rohitmisal45 have you managed to resolve the issue?