How can I change the port used by SQL for SEG, ECM, or WebMarshal?

This article applies to:

• Trustwave MailMarshal (SEG)
• Trustwave ECM/MailMarshal Exchange 7.X
• WebMarshal 6.X and 7.X

Question:

Procedure:

In current versions of all products, you can generally select a specific port in the configuration wizard. Enter the SQL server name followed by a comma (,) and the required port number. (Example: machinename,1500)

You can also alter the port and database server used by MailMarshal or WebMarshal after you complete the installation. 

By default, MailMarshal and WebMarshal use the standard port 1433 to connect to the SQL server. 

To change the Database connection (port) perform the following tasks:

Trustwave MailMarshal (SEG)

SEG/MailMarshal 6.8 and above

1. On the Array Manager machine, launch the MailMarshal Server Tool (found in the program menu under MailMarshal | MailMarshal Tools by default).
2. Select the Database item.
3. In the SQL Server Name field enter the SQL server name followed by a comma (,) and the required port number. (Example: machinename,1500)
4. For recent versions that have Syslog support, the Syslog database server port must be configured separately on the Syslog tab of the tool.
5. For MailMarshal (SEG) 10, the Config Service database connection is configured using the Config Service Admin Tool (SegCfgServiceAdminTool.exe found in the Config Service subfolder of the Array Manager install).

MailMarshal 6.0 through 6.7.X

1. On the Array Manager machine, launch the MailMarshal Server Tool (found in the program menu under MailMarshal | MailMarshal Tools by default).
2. Select the Database tab.
3. Click Change.
4. In the SQL Server Name field enter the SQL server name followed by a comma (,) and the required port number. (Example: machinename,1500)

Trustwave ECM/MailMarshal Exchange

1. On the Array Manager machine, launch the M86 MailMarshal Exchange Server Tool (found in the program menu under M86 MailMarshal Exchange | M86 MailMarshal Exchange Tools by default).
2. Select the Database item.
3. In the SQL Server Name field enter the SQL server name followed by a comma (,) and the required port number. (Example: machinename,1500)

WebMarshal

WebMarshal 6.X and 7.X

1. In the WebMarshal Console, open Global Settings (Server Properties) and select the Database Logging item.
2. Click Create Database. In the SQL Server Name field, change the name to include the port you want to use to connect with SQL. Enter the SQL server name followed by a comma (,) and the port number (Example: machinename,1500)
3. Ensure Connect using TCP/IP protocol is selected. 
4. Click OK.

Notes:

• Before changing the port setting in Marshal products, ensure that the SQL server is configured to listen on the port.
• Earlier M86 documentation recommends using a colon (:) as the separator before the port number. The comma is preferred by SQL.
• If SQL Server is running as a "named instance," you may need to enter an instance name preceded by a backslash (\) (for example, by default SQL Express installs as computername\SQLEXPRESS). Generally, use the instance name or the port number, but not both.
• See also Q11848 Installing SQL Express with WebMarshal 6.X or 7.X

This article was previously published as:

NETIQKB40087