Managing the Database and Reporting › Using Microsoft SQL Server as the Arcserve Backup Database › 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 or later and the 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 help ensure that the installation wizard can communicate with the remote system, you should enable TCP/IP communication between the Arcserve Backup server and the server that will host the Arcserve Backup database before you install 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 later--To enable TCP/IP communication on Microsoft SQL Server 2005 and later 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.