How do I determine what port the VigilEnt Security Manager database is using if Microsoft SQL Server (NETIQKB32121)

goal
How do I determine what port the VigilEnt Security Manager database is using if Microsoft SQL Server is configured to use a port other than the default port (1433)?

fact
NetIQ Vulnerability Manager 5.5

fact
VigilEnt Security Manager 3.x

fact
VigilEnt Security Manager 4.0

fact
VigilEnt Security Manager 4.1

fact
NetIQ Vulnerability Manager 5.0

fix

To verify the port used by Microsoft SQL Server perform the following steps:

1. Launch Microsoft SQL Server Enterprise Manager.
2. In the Tree window pane, expand the SQL Server used for the VigilEnt database.
3. Expand the Management folder and the SQL Server Logs.
4. Select the log labeled Current and look for an entry that begins with "SQL Server listening on".  This will list the IP Address of the server, followed by the port number.

To ensure proper communication between the Microsoft SQL database and VigilEnt Security Manager (VSM) or NetIQ Vulnerability Manager (VM), the port used by VSM or VM must be the same as the one listed in the SQL logs.  To determine what port is used by VSM refer to the following:

For VigilEnt Security Manager 3.x:

1. Go to Start | Programs | VigilEnt Security Manager | VigilEnt Security Manager Configuration Utility.
2. Select the Database tab.
3. Locate the Database URL field.  The port number will be listed to the right of the database name in the string, for example:
• jdbc:inetdae7:localhost:1433?database=vigilent.  (Where 1433 represents the port number VSM uses.)

 For  VigilEnt Security Manager 4.x:

1. Go to Start | Programs | VigilEnt | VigilEnt Security Server Configuration Utility.
2. Select the Database tab.
3. Locate the JDBC  Driver Database URL field.  The port number will be listed to the right of the database name in the string, for example:
• jdbc:inetdae7:localhost:1433?database=vigilent.  (Where 1433 represents the port number VSM uses.)

Formerly known as NETIQKB32121