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.

    There are many methods available for creating an alias for a computer that allows it to connect to the SQL port on the central administration server.

    See “To create an alias when a SQL Express instance is used”.

To create an alias when a SQL Express instance is used

  1. On the managed media server, click Start > SQL Server Configuration Manager.

  2. Expand SQL Native Client Configuration.

  3. Click Aliases, and then double-click the alias name that contains the central administration server name and the Backup Exec SQL instance name.

  4. On the alias properties dialog box, enter the appropriate information as described in the following table:

    Alias Name

    Type the name of the central administration server and the Backup Exec SQL instance name using the format server name\instance name.

    Port No

    Type the port number of the remote Backup Exec SQL Server instance that you noted in the previous procedure.

    Protocol

    Select TCP/IP.

    Server

    Type the name of the central administration server and the Backup Exec SQL instance name using the format server name\instance name.

  5. Click Apply, and then click OK.

  6. Close the SQL Server Configuration Manager utility.