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