Geneos - SQL Toolkit port definition behaviour

You may notice when trying to create a SQL-Toolkit sampler that the port field is optional and greyed out but there is a greyed out value specified. 

For example

You can see in the above screenshot that the value 1433 is specified and greyed out. This is an indication that the default value for the database type in question is port 1433. This does not mean that this is the value that is being specified by the plugin by default. 

The sampler will obtain its value directly from the database client. This means that you do not need to explicitly specify this. 

A common pitfall is to assume that the sampler is using the greyed out port value as a default - it is not. In the case below you can observe the following to illustrate this. 

A user believes their SQL-Server database is using the default port 1433 and they have explicitly specified that value

Result 

An error - HYT00 Login timeout expired08001 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. 

The user finds out the port value is in fact 1435

The user can either choose to explicitly specify this value in the plugin configuration or it can be removed. 

If you have any further questions:

• Please contact with our Client Services team via the chat service box available in any of our websites or via email to support@itrsgroup.com
  
  
  
• Make sure you provide to us:
  • ANY LOG FILE OR DIAGNOSTIC
  • ANY SCREENSHOT