Troubleshooting Remote SQL Server Issues

  • Article

Applies To: Data Protection Manager, System Center Data Protection Manager 2007

The following table provides guidance for troubleshooting remote SQL Server issues.

Remote SQL Server Issues

Issue Possible Cause Resolution

Error 812. Report deployment failed.

DPM setup fails if you choose an instance of SQL Server that is running on a Windows Server 2008 operating system x64 server.

To resolve this issue, do the following:

  1. Uninstall DPM 2007.

  2. On the Windows Server 2008 x64 computer running the remote instance of SQL Server 2005, follow the steps in Knowledge Base article 938245, "How to install and configure SQL Server 2005 Reporting Services on a computer running Windows Server 2008 (https://go.microsoft.com/fwlink/?LinkId=102506).

  3. Run DPM setup again.

Troubleshooting Error ID 4307

The following table provides guidance for troubleshooting Error ID 4307. This error occurs when you are attempting to connect to a remote SQL Server database when installing System Center Data Protection Manager (DPM) 2007.

Troubleshooting Error ID 4307

Possible Cause Resolution

Remote connection to the computer running SQL Server is disabled.

To enable the remote instance of SQL Server, do the following:

  1. From the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, in the console pane, expand SQL Server 2005 Network Configuration, and then select the network protocol for the DPM named instance.

  3. In the details pane, if TCP/IP is disabled, right-click TCP/IP and click enable.

The SQL Server Browser service is disabled.

To start the SQL Server Browser service, do the following:

  1. In SQL Server Configuration Manager, in the console pane, click SQL Server 2005 Services.

  2. In the details pane, right-click SQL Server Browser, and then click Properties.

  3. In the SQL Server Browser Properties dialog box, on the Service tab, select Automatic from the Start Mode drop-down list, and then click OK.

Note

By default, Microsoft SQL Server 2005 sets the SQL Server Browser service to start automatically.

The name of the remote instance of SQL Server is in the incorrect format.

Ensure that the remote SQL Server instance name is in the following format:

<Computer name>\<Instance name>

Note

Only use <Computer name> for the default instance.

There is no network connectivity between the DPM server and the computer running SQL Server.

Ensure there is a connection between the DPM server and the computer running SQL Server.