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

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 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.

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