Skip to main content
Delphix

MSSQL Masking job fails with 'no instance named'

 

Applicable Delphix Versions

Major Release

All Sub Releases

5.2 5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.3.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

Issue

An MSSQL masking job may fail with an Error saying there is no instance named.

Example:

2018-03-31 12:34:34,038 [http-nio-8282-exec-2] ERROR c.dmsuite.common.utils.DBConnection - Error while getting sql server Connection Object 
java.sql.SQLException: Server windowstgt.delphix.com has no instance named WINDOWS_INSTANCE.

Resolution

As per the documentation:

  • Instance Name — (MS SQL Server only) The name of the instance. This is optional. If the instance name is specified, the connector ignores the specified "Port" and attempts to connect to the "SQL Server Browser Service" on port 1434 to retrieve the connection information for the SQL Server instance. If the instance name is provided, be sure to make exceptions in the firewall for port 1434 as well as the particular port that the SQL Server instance listens to.

https://docs.delphix.com/docs/delphi...baseConnectors

Try removing the Instance Name from the connectors page and try the job again.

connector instance.png