Hi there,

This is most likely because the NMM SQL RA (Remote Agent) is not registered correctly.

Try this:

On the SQL server open a command prompt and type the following commands:

nmmnmsqlra -i

Then give it another go.

If still doesn't work, then delete the per information on NW server by typing this:

nsradmin -p nsrexec

nsradmin>. type: nsr peer information

delete name: client_name

delete?y

nsradmin>quit

where client_name is the name of the SQL server.

Thank you,

Carlos

Did you provide permissions right for service? There is an article about in KB and it applies to SQL 2012.  Next, do you plan to use VDI or VSS?  If VDI, check access via nsrsqlsv command on the client (though your user might have access so at the end of the day - unless you use user for backup - you still need to add permission to access it to service).

The backup server is on NetWorker 8.1.x too?

When you say your databases are not visible, do you mean to say when you create a client using the NMC client configuration wizard ? Can you provide a screenshot?

Also, i would just create a normal client instance and put the details manually instead of wasting time on getting the wizard work.

c:\Program Files\EMC NetWorker\nsr\bin>nsrnmsqlra -i

43708:nsrnmsqlra:Start time: Tue Sep 09 09:29:59 2014

43621:nsrnmsqlra:Computer Name: ALSSQL     User Name: ialclad

The remote agent resource with the same values already exists.

Sorry, I made a mistake on the command.

To register the Remote Agent (which is the agent to be able to use client wizard for NMM) please run this command:

nsrnmsqlra -i

Thank you,

Carlos

c:\Program Files\EMC NetWorker\nsr\bin>nmmnmsqlra -i

'nmmnmsqlra' is not recognized as an internal or external command,

operable program or batch file.

Yip 8.1

Hi there,

Try to unregister it first, then delete the peer information, and register it again.

To unregister run:

nsrnmsqlra -u

then delete peer information as described above.

Then run this command:

vssclupdate

Then register it again running:

nsrnmsqlra -i

Thank you,

Carlos

SOrry to add it is windows 2008 r2 SQL 2012

Hi,

For SQL 2012 you need to provide the SQL admin credentials (even during client creation using wizard), did you do that?

Also, do you have UAC enabled? If so please disable it.

Also when running the command please run it as admin.

And check the credentials as well in SQL connections.

Thank you,

Carlos

Hi

I have noticed this in my nsrsqlra.raw when i add the client.

I cannot see the service the service replication manager exchange interface to change the log on credentials as suggested by crazyrov.

Hi Carlos

Where do you set the client credentials during wizzard i do not see that.

My networker server properties i have set the user for sql admin and the server as below.

With the user and sql managment studio.

I can connect to sql db.

will have to scheduled reboot for UAC but have done below so far

open secpol.msc on client and:

1. Navigate to Local Policies -> Security Options.
2. Change "User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode" to "Elevate without prompting".
3. Disable "User Account Control: Run all administrators in Admin Approval Mode".
4. Restart the machine.

rebooted system and still same error. I have now gone bald or think i may be due to me pulling my hair out.

Again, have you checked permissions and KB article which discusses this permissions for SQL 2012.