Problem in backup MS SQL cluster

Question

Hi, I have a problem with MS SQL backup in cluster. I use NW 7.3.2 and nsrsqlsv 5.0 I made al configuration necessary, from the book, but, backup refuse to work: Below are logs from a client node: 1. nsrsqlsv.log [3656] 10/19/06 16:37:36 Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason. [3656] 10/19/06 16:37:36 Microsoft SQL Server Provider error: [3656] 10/19/06 16:37:36 Write on 'Legato#94befedd-eb4d-4b3e-8ef3-c57b00047568' failed, status = 995. See the SQL Server error log for more details.. [3656] 10/19/06 16:37:36 BACKUP DATABASE is terminating abnormally.. [3656] 10/19/06 16:37:36 Processing model failed, the item will be skipped. 2.xbsa.log XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:29 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:29 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 2872 Thu Oct 19 16:37:30 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01. XBSA-1.0.1 LNMs_2H_2005.Build.154 3656 Thu Oct 19 16:37:36 2006 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 1): permission denied, `sqlcls_dwncls1' on `dwncls01.domain.org' must have remote access privilege to client sqldwncls01.

dgreggs1 · Answer

The NetWorker Recover Service account is it Local System or a Service account with Administrative privileges? In SQL is the account SA? Do regular file system backups work?

dgreggs1 · Answer

You have to configure the Virtual nodes as well. E.g., On sqldwncls01:sqlcls_dwncls1@dwncls00.domain.orgsqlcls_dwncls1@dwncls01.domain.orgsqlcls_dwncls1@sqldwncls0sqlcls_dwncls1@sqldwncls1

razvan2 · Answer

Ok, but I get the same.User sqlcls_dwncls1 is a domain user of domain.org, is only in administrator, and backup operators in both physical nodes.

razvan2 · Answer

sqlcls_dwncls1 is not a client, is the domain user with backup rights om SQL SERVER.
My clients are
Phisical node:
dwncls00.domain.org
dwncls01.domain.org
Virtual node
sqldwncls0
sqldwncls1
According to documentation, I put in remote acces of:
sqldwncls0
sqlcls_dwncls1@dwncls00.domain.org
sqlcls_dwncls1@dwncls01.domain.org
and on sqldwncls1
sqlcls_dwncls1@dwncls00.domain.org
sqlcls_dwncls1@dwncls01.domain.org

dgreggs1 · Answer

Lica,Make sure on each node of the sql cluster you have the appropiate accounts on the Remote Access tab. E.gon client:sqlcls_dwncls1sqlcls_dwncls1@dwncls01.domain.orgsqlcls_dwncls2@dwncls02.domain.orguser=sqlcls_dwncls1,host=dwncls01.domain.orguser=sqlcls_dwncls2,host=dwncls02.domain.org

razvan2 · Answer

I put, user=sqlcls_dwncls1,domain=DOMAIN.ORG, in NW admin group.The result was the same.Also, from Networker user from SQL I get the same error.

dgreggs1 · Answer

What happens when you run the Legato NetWorker for SQL modules permission wizard?

On W2K03 I have had to get pretty granular with regard to my configuration. Make sure the account that kicks off save is the same account defined in SQL. I have a Domain account that is also the account that the NetWorker Service runs as because the Legato Server during the scheduled backup makes a RPC to the client and says "start your backup". The nsrexecd service is what invokes save and in this case nsrsqlsv.

razvan2 · Answer

1. nsrexecd is stared wity SYSTEM acount.2.sqlcls_dwncls1-is SA in SQL3. Yes it's work.

ble1 · Answer

Could be a fault then with SQL module - I believe at least one user said there is updated build of this module (v5) so perhaps support could give you that one.

ble1 · Answer

What happens when you define SA as admin in NW?

razvan2 · Answer

OK, I will contact support for this problemm

razvan2 · Answer

I run permision wizar, also the accout use for bakup, is also the service account that start SQL server.
Also this account is in local administrators and backup operators.
I check in local GP, and user has log on as a batch job, log on localy, and log on as a service.

razvan2 · Answer

The isue was solved with support help.I put the user in the administrator.user@node1.domain.orguser@node2.domain.orgAlso thanks to Hrvoje Crvelin, it was also his suggestions, but I didn¿t implemented right.Now it's working.Thx

xvan_egmond · Answer

Hi,we were having this same issue, but I resolved it by giving the backup user 'remote access all clients' rights by adding a new nsr user group backup_operators and adding the user to it. This is better for the security!HOWEVER we cannot start the networker user for sql on the client, it comes back with the error:Error detecting SVS root path for nlsap34.sap.publishers.intracannot find the file specifiedDoes anyone know how to detect the sql virtual server root path?

wongj · Answer

Hi,we were having this same issue, but I resolved it bygiving the backup user 'remote access all clients'rights by adding a new nsr user groupbackup_operators and adding the user to it. This isbetter for the security!HOWEVER we cannot start the networker user for sql onthe client, it comes back with the error:Error detecting SVS root path fornlsap34.sap.publishers.intracannot find the file specifiedDoes anyone know how to detect the sql virtual serverroot path? You will need to upgrade NMSQL to the lastest version and apply a hot fix.

NetWorker

Was this post helpful?