Changing the dynamic port on the SQL Express instance in CASO to a static port

You must change the port on which the Backup Exec SQL Express instance for the central administration server is running from a dynamic port to a static port. Then, create an alias for the managed media server to allow it to connect to the SQL port on the central administration server. After changing the port, you must restart the Backup Exec and Microsoft SQL services on the central administration server.

To change the dynamic port for a SQL Express instance to a static port

  1. On the central administration server, click Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.

  2. Expand SQL Server 2005 Network Configuration.

  3. Click Protocols for BKUPEXEC, and then in the right pane, double-click TPC/IP.

  4. On the TCP/IP Properties dialog box, click the IP Addresses tab.

  5. Under IPAll, in TCP Dynamic Ports, remove the value and leave the field blank.

  6. Under IPAll, type in a port number for TCP Port.

    The port number can be between 1025 and 65535 and must not be in use by another application.

    See Troubleshooting restore issues.

  7. Under the heading for the specific network interface card that is being used, such as IP1 or IP2, change Enabled from No to Yes.

  8. Under that same heading, in TCP Dynamic Ports, remove the value of 0, and type the same port number you entered for TCP Port.

  9. Click Apply.

  10. You must restart the Backup Exec and SQL services.

  11. Create an alias for the managed media server to allow it to connect to the SQL port on the central administration server.

    See Creating an alias for a managed media server when a SQL Express instance is used.

Changing the dynamic port on the SQL Express instance in CASO to a static port