Troubleshooting Remote SQL Server Issues

  • Article

Applies To: System Center Data Protection Manager 2010

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) 2010.

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 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, in the console pane, expand SQL Server 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 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 sets the SQL Server Browser service to start automatically.

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

Make sure that the remote instance of SQL Server 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.

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