Skip to main content
Delphix

Resolving "No Instance Named" Error on MSSQL Masking Job (KBA1313)

 

Troubleshooting Error No Instance Named

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

To resolve error try removing the Instance Name from the connectors page and try the job again.

connector instance.png

  • 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.

For more information, see Managing Connectors.

Applicable Delphix Versions 

This article applies to the following versions of the Delphix Engine:

Major Release

Sub Releases

5.3 5.3.0.0
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