Introducing CA ARCserve Backup › Installation Considerations › Database Requirements › Microsoft SQL Server Database Considerations › How to Enable TCP/IP Communication on Microsoft SQL Server Databases

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.