

The archive files to find the port information, because this is only stored in theĪlso, if you are using endpoints, such as Database Mirroring these will show Sp_cycle_errorlog to cycle the SQL Server Error Logs you will need to look in Increase the Number of SQL Server Error Logs. SQL Server Error Logs from the default value of six. However, it is a Best Practice to increase the number of Want to search for to further refine the resultsįor results: N'asc' = ascending, N'desc' = descendingīy default, there are six archived SQL Server Error Logs along with the ERRORLOG Value of error log file you want to read: 0 = current, 1.The parameters you can use with XP_READERRRORLOG are mentioned below for your Log to find the port the SQL Server Database Engine is listening. XP_READERRORLOG extended stored procedure to read the SQL Server Error You can execute the below TSQL command which uses the To the port in which an instance of the SQL Server Database Engine is listening. The SQL Server Error Log records information with respect The SQL Server Error Log is a great place to find information about what is happening 1 - Identify Port used by Named Instance of SQL Server Database Engine by Reading Let's take a look at each of the above options in detail. In this tip we will take a look at three different ways you can identify the You have changed the default port then it may be difficult to know the port used If you have more than one instance of SQL Server running on the same server or if Port 1433 for TCP/IP connections and port 1434 is used for UDP connections. Host and port are TCP server host and port number.You probably know that by default, the SQL Server Database Engine listens on Plugin is installed, we now need to enable the tcp-body-log plugin in kong:Ĭurl -X POST -data "name=tcp-body-log" -data "config.host=127.0.0.1" -data "config.port=9563".You need to add this into kong config file. Copy the lua files into tcp-body-log directory -> a, log.lua, a.usr/local/share/lua/5.1/kong/plugins/tcp-body-log Create a directory with name "tcp-body-log" in Kong's plugin directory.This plugin logs the request and response body along with other information which TCP log plugin writes. This plugin provides an extension to Kong's TCP Log plugin which logs everything but the request and response body. Log request and response data along with body to a TCP server.
