Unsolved
This post is more than 5 years old
7 Posts
0
3867
July 27th, 2012 03:00
NMM SQL backup
Hi All,
I'm trying to get NMM to work with SQL 2005 but getting an error.
I performed Config Checker and received Fail in SQL section:
SQL_AVAILABILITY - Microsoft SQL Server is not installed in the machine
But SQL server is installed and works fine.
Any thoughts?
Many thanks in advance!
No Events found!
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
July 27th, 2012 09:00
Could it be that user you run this check with does not have enough privileges to attach to SQL server?
gigamozg
7 Posts
0
July 30th, 2012 00:00
Hi Hrvoje,
Thanks for your reply!
No, it doesn't seems so - I used local Adm account for these tests and SQL server works with Windows authentication as well.
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
July 30th, 2012 13:00
OK, back to the first post - do you get error with checker only or with NMM itself when trying to connect to SQL instance? Did you previously use NMSQL where this worked?
gigamozg
7 Posts
0
July 31st, 2012 05:00
The problem is that NMM SQL backups on this server completed with failure.
The error message is:
savegrp: suppressed 2 lines of verbose output
63372:nsrsnap_vss_save:NMM .. Registration of snapshot set failed -- NMM .. Operation unit failed with error Please make sure you have configured at least one NetWorker Device and client resources are configured for the application host[***] and the proxy client[***] on NetWorker Server [***]
77175:nsrsnap_vss_save:NMM .. completed commit replica with status of false.
63335:nsrsnap_vss_save:NMM backup failed to complete successfully.
Internal error.
68151 1343734894 2 0 0 24452 24040 0 *** nsrsnap_vss_save 39 nsrsnap_vss_save: Exiting with failure. 0
com] on NetWorker Server [***].
64038:nsrsnap_vss_save:NMM .. Error creating NetWorker backup of snapshot: NMM .. Operation u
I didn't use NMSQL before.
Many thanks in advance!
deannajh
23 Posts
0
August 2nd, 2012 09:00
What version of NMM are you using? And back to the question about the checker, did you run the config checker to validate your environment prior to the installation? I
gigamozg
7 Posts
0
August 2nd, 2012 23:00
Hi Hrvoje,
I'm using NMM v. 2.3.2 and it has MS SQL module.
At least it works fine on my another server with similar config (the difference between these two is only in SQL version: 2005 vs 2008).
OK, thanks for your advice, I will try version 2.4.
Hope it will help!
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
August 2nd, 2012 23:00
It looks like you are using previous version of NMM without NMSQL integrated. I would suggest to start with NMSQL alone first (5.2SP2). In recent version of NMM (2.4), NMSQL is included and it would be my weapon of choice against SQL backup.
gigamozg
7 Posts
0
August 2nd, 2012 23:00
Hi Deannajh,
I'm using NMM version 2.3.2 x64.
No, I didn't run the config checker prior to the installation on this server.