We are currently masking for one of the SQL server application. We are successfully able to create connector, rule and job and able to test it also.
But while running the job it is throwing below error:-
"Error occurred while trying to connect to the database. Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver).Unable to get information from SQL Server: xxxxxxxxxx.xmp."
We tried to manually test the connection using SQL server management studio and were able to do so, but after running the job still we are getting above error.
Could you please provide your input on this? Thanks in advance.