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 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 supported versions

1. On the Array Manager machine, from the Start menu launch the MailMarshal Server Tool.
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 from the Start menu.

Trustwave ECM/MailMarshal Exchange

1. On the Array Manager machine, from the Start menu launch the MailMarshal Exchange Server Tool.
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 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.

This article was previously published as:

NETIQKB40087