UNSOLVED

ulma

updated

16 years ago

U

ulma

5 Posts

0

1584

June 14th, 2010 08:00

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.

  • 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

  • ulma

    5 Posts

    531

    0

    Posted June 15th, 2010 02:00

    Hi!

    I have resolved the problem.

    I have to install the networker module with domain administrator and put the user and password in the clien configuration.

    Thanks for all.

    Ana.