Export (0) Print
Expand All

Troubleshooting Remote SQL Server Issues

Updated: April 21, 2010

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.

noteNote
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>

noteNote
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft