PRB: SQL Server 7.0 Setup Fails on MSCS with Cannot Grant Logon as a Service Right (270839)



The information in this article applies to:

  • Microsoft SQL Server, Enterprise Edition 7.0

This article was previously published under Q270839

SYMPTOMS

When you install SQL Server 7.0 Enterprise Edition on a Microsoft Cluster Server (MSCS), an error message similar to following occurs (the hex numbers may vary from one computer to the next):
Setup cannot grant log on as a service right to the specified account: 2117340 (0xc0000022)

CAUSE

The preceding error message occurs when you install SQL Server 7.0 Enterprise Edition on a Microsoft Cluster Server (MSCS) if you are logged on to the computer with an account that does not have enough permissions on both nodes.

WORKAROUND

To work around this behavior:
  1. Create a Microsoft Windows NT domain service account for SQL Server. If you already have a Microsoft Windows NT domain service account, verify that it has the following advanced user rights:
    • Act as part of the operating system.
    • Logon as a service.
    • Logon locally.


  2. Make sure that this account is a member of the local Administrators group on both nodes.
  3. Logon to both nodes in the cluster by using the SQL Server Service account from step 1.
  4. Install Microsoft SQL Server 7.0 Enterprise Edition from the CD.

MORE INFORMATION

For additional information about installing SQL Server 7.0 on a Microsoft Cluster Server, see the following article in the Microsoft Knowledge Base:

219264 INF: Order of Installation for SQL Server 7.0 Clustering Setup


Modification Type:MinorLast Reviewed:1/5/2006
Keywords:kbprb KB270839