
UNSOLVED
Backup Error with Sql 2008
Hi All!!
I have a problem with my first backup of Sql 2008.
I'm cofiguring the client and when I try to open networker module for sql, I get the next error: "37955:nwssql" and "Can not login to SQL Server" and SQL logon failed".
If I try to make a backup, I have these error:"A required privilege is not held by the client" and the backup fail.
I give permissions to the user in the Sql Server (local administrator and backup operator) and also in the sysadmin role for sql, but I have the same problem.
What might be reason of this problem?
I use Networker 7.4.5 and nmsql521 backup for sql 2008.
Can someone help me?
Thanks.
Ana.
Responses (2)
Solutions (0)

elvinperez
87 Posts
531
1
Posted June 14th, 2010 12:00
Hello,
Verifiqued this permission.
Setting access rights for the NetWorker Module
The NetWorker Module for Microsoft SQL Server on Windows Server 2003 requires
access to various system folders and resources. By default, non-administrator user
accounts are limited and do not have the necessary privileges to run the NetWorker
Module. The following steps enable a local system administrator to configure these
user accounts to run the NetWorker Module for Microsoft SQL Server.
To grant the permissions to NetWorker Module for Microsoft SQL Server for accounts
that are not the members of the local administrator group, set the following registry
and file objects permissions:
1. Make sure that the security settings on the applogs directory, under the
NetWorker Module for Microsoft SQL Server installation path, allow
Modify.
(The default installation path is C:\Program Files\Legato\nsr\applogs).
2. Make sure that the following registry keys have the following permissions set:
Native registry keys
• HKLM\Software\Legato\BSMSQL\Environment (
Full)
• HKLM\Software\Microsoft\DataAccess (
Read)
• HKLM\Software\Microsoft\MSSQLServer (
Read)
• HKLM\Software\Microsoft\Microsoft SQL Server (
Read)
WOW64 registry keys (32-bit SQL Server on 64-bit systems)
• HKLM\Software\Wow6432Node\Microsoft\MSSQLServer (
Read)
• HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server (
Read)
3. Make sure that the account is also:
• Able to Create Global Objects under the local Security Policy, which is
required by the SQL VDI interface used by this module.
• A member of the Backup Operator’s group.
• Included in the sysadmin role within SQL Server.
The Microsof