I am attempting to ingest data from Windows based SQL Server from Dbconnect on linux HF.
We are not allowed to use jtdc driver since it is not SSL encrypted. What is the alternative to connect to windows based database?
I believe i might have to create service account for the machine that is hosting sql server. but do i need anything else? I have allowed port no to the sql server host.
Database can access through RDPing into instance --> SQL Mangement Studio
Created service account and added Database read-only AD group
Create Identity with Service account for username , password with Use Windows Authentication Domain - CHECKED and added domain
Dbconnect connection configs:
- Have added hostname: fqdn\SQL1 , port 51565 ( firewall rules have been added)
- Added default database name
- Attempted to create connection for Microsoft Generic Driver (4.2 version) - having issue:
Login failed for user 'xxxxx'. ClientConnectionId:xxxxxxxxxxxxxxxx