This post is more than 5 years old
37 Posts
0
1339
February 4th, 2015 00:00
NMM 3.0.1 MSSQL group always failed
Hi, I have a problem with MSSQL 2012 database NMM backup running on Win2012 Server and need help. My environment:
Networker Server: 7.6.5
Client Version: 8.1.1.2 Build 280 + NMM Version 3.0.1 (NMM 3.0 SP1).
First of all: Yes, we have an old NW version on our NW Server. Update of NW Server is scheduled on next week.
NMM 3.0.1 was installed because 3.0 is incompartible with Win2K12 or SQL2K12(at least I had this message during installation). Client 8.1.1.2 was installed because 8.1.0 is incompartible with NMM 3.0.1.
Succesfully added Client on NW Server. It "sees" all of bases with no problem. But when I try to start group it is always Failed with message:
Probe job unrecoverable failure(s), this job is being abandoned.
What is the reason in my case?:
1. Too high client or NMM version for current NW Server?
2. Any kind of incompartibility with Win2K12 or SQL Server 2K12?
I have a workaround using SQL Server dump backup and regular client but need to use NMM for this base.
Thank you very much for your time
CarlosRojas
1.7K Posts
0
February 4th, 2015 02:00
Try to give the SYSTEM service permissions in SQL as follows:
dbcreator
public
sysadmin
And give it a try.
Thank you,
Carlos
Godzy
37 Posts
0
February 4th, 2015 02:00
Yep, should work
Godzy
37 Posts
0
February 4th, 2015 02:00
Thank you for your answers. As far as I know it is required for 2012
crazyrov
4 Operator
•
1.3K Posts
1
February 4th, 2015 02:00
that is the reason the probe is failing. Keep the user name and password blank and the probe should complete successfully.
crazyrov
4 Operator
•
1.3K Posts
1
February 4th, 2015 02:00
Hi Godzy,
Have you put a user name and password in the client properties ?
Godzy
37 Posts
0
February 4th, 2015 02:00
Will ask DB Adm to check username/password.Now I see that's the reason
CarlosRojas
1.7K Posts
0
February 4th, 2015 02:00
For SQL 2012 the username and password is required.
Godzy
37 Posts
0
February 4th, 2015 04:00
Yep, it works
Thank you very much for help
Godzy
37 Posts
0
February 4th, 2015 04:00
It works using domain account for backup jobs.