Error while creating a SQL Client instance using Client Configuration Wizard, the error is: “Referenced object does not exist”

Cause:

Client Wizard uses SQL Distributed Management Objects (SQL-DMO) to communicate with SQL Server to populate its databases to be configured as savesets from the wizard.

It used to be part of the SQL Server package before. However, with SQL Server 2008, it was split out into a separate feature pack. So to use Client Wizard for SQL Server 2008 you have to install SQL-DMO separately on the SQL Server Client.

Resolution

Install the SQL Server 2005 Backward Compatibility Components, Which can be downloaded from the following Microsoft Website:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16177

Download the SQL Server 2005 Backward Compatibility Components correspond to your SQL platform (x86, x64 or IA64)

Firstly, Make sure that the Strong Authentication (nsrauth) is Enabled on the client as it is a required setting for the wizard and the browse icon features to function. To check if it is enabled or not, try the following steps:

Open a cmd prompt from the client, and run:

nsradmin -p nsrexec

nsradmin> show auth methods

nsradmin> print type: nsrla

auth methods: “0.0.0.0/0,nsrauth/oldauth”;

Note: make sure nsrauth is on

If nsrauth not on, so you have to enable it on the NetWorker Client. Here are the steps to accomplish this task from the command prompt on the client:

C:\nsradmin -p nsrexec
NetWorker administration program.
Use the “help” command for help.
nsradmin> . type: nsrla
Current query set
nsradmin> show auth methods
nsradmin> print
auth methods: “0.0.0.0/0,oldauth”;
nsradmin> update auth methods: “0.0.0.0/0,nsrauth/oldauth”
auth methods: “0.0.0.0/0,nsrauth/oldauth”;
Update? y
updated resource id 2.3.80.1.70.157.87.68.67.190.164.357(32)
nsradmin> print
auth methods: “0.0.0.0/0,nsrauth/oldauth”;
nsradmin> quit

Restart the NetWorker services on the NetWorker Client.

If the problem still exists, you have to delete the nsr peer information from the client.

Use the following commands to delete the NSR Peer Information

C:\nsradmin -p nsrexec
NetWorker administration program.
Use the “help” command for help.
nsradmin> . type: nsr peer information

Current query set

nsradmin> print

type: NSR peer information;
administrator: Administrators,
“group=Administrators,host=Egy”;
name: Bebo;
peer hostname: Bebo;
Change certificate: ;
certificate file to load: ;

nsradmin> delete

delete? y

deleted resource id 2.3.80.1.70.157.87.68.67.190.164.357(32)

nsradmin> quit

Note: Delete all ‘nsr peer information’ entries on that client.

Restart Networker services on client.