Backup Exec 11d Managed Media Server's (MMS) Device and Media service fails with the following error "The database specified does not exist" in a firewall environment .

Article:TECH83117  |  Created: 2004-01-29  |  Updated: 2011-09-15  |  Article URL http://www.symantec.com/docs/TECH83117
Article Type
Technical Solution

Product(s)

Environment

Issue



Backup Exec 11d Managed Media Server's (MMS) Device and Media service fails with the following error "The database specified does not exist" in a firewall environment .


Error



The database specified does not exist.


Cause




Firewall is blocking the port of SQL Server instance on the CAS as a result MMS is unable to communicate  through the firewall. 
 


Solution




Installing a managed media server across a firewall can cause communication issues with (CAS) resulting in the error "The database specified does not exist" if the communication ports for  MMS (SQL 2005 Express) are not opened at the firewall.


If a managed media server is installed outside the firewall or if it is installed in a different firewall then the central administration server is installed in,  Following steps are  required  to enable communication for the Backup Exec Server service  in both directions:

1. Port 3527 must be open in both directions to enable communication for the Backup Exec Server service.

2. An open port range must be available for the Remote Agent for Windows Servers, which will allow browsing for remote selections.

3. A SQL port must be open in both directions to the central administration servers database to enable database connections.


Note : Named instances of the SQL Server Database Engine are configured for dynamic ports, which means they select an available port when the SQL Server service is started. When connecting to a named instance through a firewall, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.

The Backup Exec SQL instance is configured by default to use a dynamic port. Each time SQL Server is started, a new  port is assigned but this can be changed to a static port. Refer to Microsoft KB article given at the end of this technote on how to change a dynamic port to a static port.


Determining the ports Backup Exec SQL Express instance is running on the Central Administration Server :


To find the port on which the Backup Exec SQL Express instance is running:

Note: By default, a named instance of SQL Server listens on a dynamic port, therefore its recommended to assign a static port to SQL instance so that specific port can be opened at Firewall instead of opening the whole range of Dynamic ports which is less secured. To assign the static TCP port please refer to the Microsoft KB article: 823938 given at the related section below. Once the static port is assigned follow the remaining steps given below.

1.  On the central administration server, click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager  as shown in Figure 1 below.

Figure 1:
 
 

2. Expand SQL Server 2005 Network Configuration as shown in Figure 2 below.

Figure 2:
 
 
 
3. Click Protocols for BKUPEXEC, and then right-click on TPC/IP and select properties  as shown in Figure 3 below.

Figure 3:
 
 

4. On the TCP/IP Properties dialog box, click the IP Addresses tab as shown in Figure 4 below.

Figure 4:
 


5. Note the port number that is displayed as shown in Figure 5 below. In this example Backup Exec SQL instance is already configured to use Static Port but that may not be a case always.

Figure 5:
 


6. Create an alias for the managed media 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. Following is an example of one method.


To create an alias for the managed media server :

1. On the managed media server, click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager

2. Expand SQL Native Client Configuration as shown in Figure 6 below.

Figure 6:
 

3. Click Aliases and select New Aliases as shown in Figure 7 below.

Figure 7:
 
 

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

Figure 8:
 

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


Determining the ports for Backup Exec SQL 2000 or MSDE instance running on the Central Administration Server :


Note: By default, a named instance of SQL Server listens on a dynamic port, therefore its recommended to assign a static port to SQL instance so that specific port can be opened at Firewall instead of opening the whole range of Dynamic ports which is less secured. To assign the static TCP port please refer to the Microsoft KB article: 823938 given at the related section below. Once the static port is assigned follow the remaining steps given below.


1. On the central administration server, use the svrnetcn.exe utility to determine the port on which the Backup Exec SQL instance is running. The "svrnetcn.exe" utility is located in following directory :

Location: \Program Files\Microsoft SQL Server\80\Tools\Binn as shown in Figure 9 below:

Figure 9:
 


a. On the General tab, select the Backup Exec SQL instance as shown in Figure 10 below.

Figure 10:
 

b. Under Enabled Protocols, select TCP/IP, and then click Properties and note down the Default port number as shown in Figure 11 below.

Figure 11:
 


2. On the managed media server, use the SQL Server Client Network Utility (cliconfg.exe) to create an alias for the managed media server The "cliconfg.exe" utility is located in the following directory :

Location:  \Windows\System32\cliconfg.exe as shown in Figure 12 below.

Figure 12:
 

a. On the Alias tab, click Add as shown in Figure 13 below.

Figure 13:
 

Enter the following values as shown in figure 14 below.

Figure 14:
 

b. In the Server alias field, type:server name\instance name

c. Under Network libraries, select TCP/IP. ( In some environments, you may need to also check Named Pipes).

d. In the Server name field, type: server name\instance name

e. Clear the Dynamically determine port check box

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


Related Microsoft KB articles:

1. How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager).  
 http://msdn2.microsoft.com/en-us/library/ms177440(SQL.90).aspx

2. How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port.
 http://support.microsoft.com/default.aspx?scid=kb;en-us;823938

3. How to: Create a Server Alias for Use by a Client (SQL Server Configuration Manager).
 http://msdn2.microsoft.com/en-us/library/ms190445(SQL.90).aspx

4. How to connect to a named instance of SQL Server 2000 or SQL Server 2005 by using the client tools in the earlier version of SQL Server.
 http://support.microsoft.com/kb/265808/en-us

5. INF: TCP Ports Needed for Communication to SQL Server Through a Firewall.
 http://support.microsoft.com/kb/287932/
 

Supplemental Materials

SourceETrack
Value229576
Description

MMS behind a firewall needs a proper Alias configuration



Legacy ID



273320


Article URL http://www.symantec.com/docs/TECH83117


Terms of use for this information are found in Legal Notices