IBM Support

Hostname format is not correct

Troubleshooting


Problem

When creating a Data Source for IBM Secure Gateway, on Planning Analytics Administration, the above message is reported.

Environment

IBM Secure Gateway

Planning Analytics Administration

Source is Microsoft SQL Server and named instance, as oppose to the default instance.  (servername:instance_name)

Resolving The Problem

Create the data source using the database server IP address AND the Microsoft SQL Server instance tcp port #

You can find that port # from Microsoft SQL Server Configuration Manager, open the instance in question, select tcp/ip and use the tcp port # defined for this named instance.

In PAA (Planning Analytics Administration) AND in the ACL file (on the IBM Secure Gateway Client server), the data source will read as IP:tcp port.

Once you have made those changes, restart the IBM Bluemix Secure Gateway Service and test the data source.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"Planning Analytics Administration, IBM Secure Gateway","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 September 2021

UID

ibm10734685

Page Feedback