[HostName / Ip] HostName or Ipaddress of machine where MsSQL server is running
[Port Number] Port number of the MsSQL server
[Authentication] SQL (or) Windows based authentication for connecting to MsSQL
[Username] User name for connecting to MsSQL ( For windows authentication , Username should be mentioned as DomainName\UserName )
[Password] Password for connecting to MsSQL
[Instance Name] If you want to connect to the MsSQL using a Named SQL instance, mention the Instance Name otherwise leave it as blank[SSL Encryption] SSL Encyption is true if the SQL Server configured for secured connection via SSL protocol. It will be false for Non-SSL/TLS connections.
For Kerberos authentication
Usage : MsSQLDebug.bat [Database_FullyQualified_HostName] [Port Number] [Authentication] [Password] [Instance Name]
[Database_FullyQualified_HostName] HostName where MsSQL server is running. Fully Qualified Domain Name should be specified If Kerberos authentication is chosen. For example : mssql-test-1.mykerberos.com where mssql-test-1 is SQL server's host and mykerberos.com is its domain name.
[Port Number] Port number of the MsSQL server
[Authentication] Should be specified as 'Kerberos'. Kerberos based authentication for connecting to MsSQL
[Password] Kerberos Principal password for connecting to MsSQL ( If ticketCache or Keytab is configured for connection then give password as null, otherwise enter the password )
[Instance Name] This is optional. If you want to connect to the MsSQL using a Named SQL instance, mention the Instance Name otherwise leave it as blank
Note: If you run using Named SQL instance, then you can enter a dummy port number in the monitor and debug script as well.
This will initiate the process to discover the MsSQL Server and on success will also fetch the data for the default attributes monitored and shown as the output. From this you will be able to find If discovery is possible, If data is returned for all attributes or not. In case there is any issue for an attribute data it'll be shown as null. This infers that the data is not available in that server and has to be checked on the MsSQL installed server.
For more info or assistance do send us the output of the above command for analysis along with Support Information File.