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