dcsimg

MS SQL 2008 fails to install, states error Access Denied

Products

Webtrends Analytics 9.2a/b
Webtrends Analytics 8.7

Issue

MS SQL Server 2008 fails to install, resulting in an error message that states “Access Denied.” Or install crashes sometimes accompanied by the error: “Not all privelages or groups referenced are assigned to the caller”.

Resolution

This failure may be caused by a system or domain policy removing the “SeDebugPrivilege” or the “SeSecurityPrivelage” security privilege from the Administrator account running the setup process. The MS SQL Server 2008 installation process requires these privileges to start up the SQL Server process and listen for an event that indicates the SQL Server started successfully.

Verify that the account under which this service is running has this privilege by performing the following steps:

For the “Debug programs” security policy:

  1. Navigate to “Administrative Tools > Local Security Policy > User Rights Assignment.”
  2. Right-click on “Debug Programs” and select “Properties.” The Debug programs Properties dialog box displays.
  3. Assign the account or group to the policy and click “Apply” to save the change.
  4. Restart the server and attempt the installation again.

For the “Manage auditing and security log” security policy:

  1. Navigate to “Administrative Tools > Local Security Policy > User Rights Assignment.”
  2. Right-click on “Manage auditing and security log” and select “Properties.” The Manage auditing and security log Properties dialog box displays.
  3. Assign the account or group to the policy and click “Apply” to save the change.
  4. Restart the server and attempt the installation again.

More Information

Assigning local security policies for the Webtrends service account.