Troubleshooting Remote SQL Server Issues
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:
|
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:
|
The SQL Server Browser service is disabled. |
To start the SQL Server Browser service, do the following:
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. |