Opening a SQL port in CASO for a SQL 2000 or 2005 instance

You must find the port number on which the Backup Exec SQL 2000 or 2005 instance for the central administration server is running, and then create an alias for the managed media server.

To open a SQL port for a SQL 2000 or 2005 instance

  1. On the central administration server, go to \Program Files\Microsoft SQL Server\80\Tools\Binn and double-click svrnetcn.exe.

  2. On the General tab, select the Backup Exec SQL instance.

  3. Under Enabled Protocols, select TCP/IP, and then click Properties.

  4. Note the port number that is displayed.

  5. 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 2000 or 2005 instance is used”.

To create an alias when a SQL 2000 or 2005 instance is used

  1. On the managed media server, to create an alias for the managed media server, go to \Windows\System32 and double-click cliconfg.exe.

  2. On the Alias tab, click Add.

  3. In the Server alias field, type:

    server name\instance name
    
  4. Under Network libraries, select TCP/IP.

  5. In the Server name field, type:

    server name\instance name
    
  6. Uncheck Dynamically determine port.

  7. In the Port number field, type the port number of the remote Backup Exec SQL Server instance.

More Information

Using Backup Exec with firewalls