-
Titolo
SQL Server agent does not use the FQDN for the physical hostname -
Descrizione
Currently the SQL Server agent retrieves the physical hostname from the database using Select ServerProperty ( 'ComputerNamePhysicalNetBIOS' ) as host_name
-
In the installer -used to create the IC agent
-
In DBSSGetProcessIdProcessor - Used for the GV and overview
When trying to create SQL Server agent with a Window Agent using the command line with FQDN entries, the Windows Agent is created using only the hostname because this is stored in the database.
-
-
Causa
Design
-
Risoluzione
WORKAROUND
Contact Support for hotfix HFIX-502 for this issue.
STATUS
Enhancement ID FOG-9787 was logged to create Windows agents using the FQDN (Fully Qualified Domain Name). This will be included in an upcoming release of the SQL Server agent.
Note: The resolve of the physical hostname to FQDN will work only if the FglAM machine is configured with the organization’s DNS server
-
ID difetto
FOG-9787