Need assistance on SQL server application Masking

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered

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.

 

Regards,

Ashok Kumar.

Photo of Ashok Kumar

Ashok Kumar

  • 240 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb
Hi Ashok,

Are you using Instance Name and Port both in your connector ? If yes,  please remove the instance name and retry once.

Regards,
Mayank
Photo of Ashok Kumar

Ashok Kumar

  • 240 Points 100 badge 2x thumb

Hi Mayank,

Yes, It is working now. Thank you so much for your help.

I have one more question. Does Delphix  5.2.6.1 version support T SQL scripts in Masking Pre-script?

Photo of MichaelT

MichaelT, Official Rep

  • 2,024 Points 2k badge 2x thumb
Hi Ashok,
T-SQL is not supported directly within prescripts. You can call a stored procedure which can contain T-SQL, from what I've been told by our field team, but within a prescript you cannot declare variables and such.

Thanks,
Michael