How can I execute a MsSQLDebug.bat / MsSQLDebug.sh file?
This file is used to check if the connectivity and the Discovery of the MsSQL Server is possible from the Applications Manager installed server. This standalone program is a excerpt of the same process we use to add the MsSQL Server monitor. The usage to run this file is as below
Via command prompt goto AppManager/bin/troubleshooting directory and execute the MsSQLdebug file with the usage below.
Usage : MsSQLDebug.bat [HostName / Ip] [Port Number] [Authentication] [Username] [Password] [Instance Name]
[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
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.
Via command prompt goto AppManager/bin/troubleshooting directory and execute the MsSQLdebug file with the usage below.
Usage : MsSQLDebug.bat [HostName / Ip] [Port Number] [Authentication] [Username] [Password] [Instance Name]
[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
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.
Related Articles
How to execute ServerSSHTroubleshoot.bat or sh file ?
Solution: Execute the file ServerSSHTroubleshoot.bat or sh from the <AppManager_home>\bin\troubleshooting folder (<AppManager_home>\bin in older versions of Applications Manager). Via command Prompt Execute the ServerSSHTroubleshoot.bat or sh file. ...How to execute ServerSSHTroubleshoot.bat or sh file ?
Execute the file ServerSSHTroubleshoot.bat or sh from the <AppManager_home>\bin\troubleshooting folder (<AppManager_home>\bin in older versions of Applications Manager). Via command Prompt Execute the ServerSSHTroubleshoot.bat or sh file. It will ...How can I execute UpdateHostnameandIP.bat/sh ?
Here are the steps to execute UpdateHostnameandIP.bat/sh: 1) Execute <AppManager_Home>\bin\troubleshooting\UpdateHostaneandIP.bat/sh file. For example, updateHostNameAndIp.bat/sh [Previous HostName/IpAddress] [new HostName/IpAddress] ...How can I execute the popTest.bat / popTest.sh file?
This file is used to check if the connectivity and the Discovery of the POP Server is possible from the Applications Manager installed server. This standalone program is a excerpt of the same process we use to add the POP Server monitor. The usage ...How can I execute a SharePoint.bat / SharePoint.sh file?
This file is used to check if the connectivity and the Discovery of the Sharepoint Server is possible from the Applications Manager installed server. This standalone program is a excerpt of the same process we use to add the Sharepoint Server ...