Updated: September 22, 2016
The MSSQL Auditor connects to SQL on the default TCP port 1433. If the customer has a custom port and is unable to return it to the default, you can edit the MSSQLAuditor.config configuration file to include the custom port.
- All versions of LEM
- MSSQL Auditor installed
You can verify the TCP port being used by connecting to the SQL Server and checking the SQL Server Configuration Manager:
- Expand SQL Server Network Configuration.
- Select Protocols for <SQL Instance Name>.
- Verify that TCP/IP is enabled.
Note: If it is not, you will need to enable this for the MSSQL Auditor to connect.
- Double-click on TCP/IP to enter the properties.
- Select the IP Addresses tab.
- Scroll through the settings to confirm the TCP port.
Note: The default port is 1433. If the port is listed otherwise note it for the next section.
To use the custom port as discovered in the above steps:
- Stop the MSSQL Auditor.
- Edit the MSSQLAuditor.config file.
Note: You will need to be running your text editor as admin. Default location is C:\Program Files (x86)\SolarWinds Log and Event Manager MSSQL Auditor
- For the Server string information, you will need to add a Port tag with the custom port.
Before: <server name="<Hostname or IP>" instance="<SQL instance>" tdf=""/>
After: <server name="<Hostname or IP>" instance="<SQL instance>" port="<custom port> tdf="" />
- Save the file.
- Start the MSSQL Auditor again.