Computer Associates BABWBR1151S38 Implementation Guide - Page 53
How to Enable TCP/IP Communication on Microsoft SQL Server Databases, Agent for ARCserve Database
UPC - 757943307405
View all Computer Associates BABWBR1151S38 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 53 highlights
Database Requirements How to Enable TCP/IP Communication on Microsoft SQL Server Databases If you are hosting the ARCserve database instance using Microsoft SQL Server 2000, Microsoft SQL Server 2005, or Microsoft SQL Server 2008, and the CA ARCserve Backup database will reside on a remote system, the installation wizard may not be able to communicate with the database on the remote system. To ensure that the installation wizard can communicate with the remote system, you should enable TCP/IP communication between the CA ARCserve Backup server and the server that will host the CA ARCserve Backup database before you install CA ARCserve Backup. ■ Microsoft SQL Server 2000--To enable TCP/IP communication on Microsoft SQL Server 2000 systems, run the SQL Server Network utility and ensure that TCP/IP appears in the Enabled Protocols. If TCP/IP does not appear in the Enabled Protocols list, add TCP/IP to the list and click OK. To apply TCP/IP communication, restart all Microsoft SQL Server services. ■ Microsoft SQL Server 2005 and Microsoft SQL Server 2008--To enable TCP/IP communication on Microsoft SQL Server 2005 and Microsoft SQL Server 2008 systems, run the SQL Server Configuration Manager and enable TCP/IP communication for the SQL Server instance. To apply TCP/IP communication, restart all Microsoft SQL Server services. Note: For Microsoft SQL Server 2008, you must use the SQL Server Native Client 10.0 driver. Agent for ARCserve Database The CA ARCserve Backup Agent for ARCserve Database is a form of the CA ARCserve Backup Agent for Microsoft SQL Server. The agent is either installed automatically when you install CA ARCserve Backup, or manually using a special utility, either after the location of the CA ARCserve Backup database is changed, or on multiple nodes of a cluster. This utility, named SQLAgentRmtInst.exe, is placed in the Packages sub-folder of the CA ARCserve Backup home directory, in a folder named ASDBSQLAgent, when you install CA ARCserve Backup. If you need to install the agent on a computer that is not a CA ARCserve Backup server, you must copy the ASDBSQLAgent folder to the system where you are installing the agent, and run the SQLAgentRmtInst.exe utility on that machine. By itself, the Agent for ARCserve Database allows you to back up and restore the CA ARCserve Backup database, and the system databases and Disaster Recovery Elements from the Microsoft SQL Server instance that contains the CA ARCserve Backup database. When installed with the Agent for Microsoft SQL Server, it allows the Agent for Microsoft SQL Server to recognize the presence of a CA ARCserve Backup database, and to work with CA ARCserve Backup to provide the special recovery mechanisms that are available for the CA ARCserve Backup database. Chapter 3: Planning CA ARCserve Backup Installations 53