RE: Services login policies and rights question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 04/05/04 

Date: Mon, 05 Apr 2004 07:26:23 GMT

Hi Frankm,

I learned you failed to install SQL Server Clustering using SQL Service
Account. Based on my experience, it likes a windows installation permission
problem. Could you please provide the detailed error message? When did the
error occur? Please describe it in detail.

As I know, there are a few Windows-level accounts that need to be
configured prior to installing both the server cluster and the SQL Server
2000 virtual server.

a. An account must be created for the administration and ownership of the
server cluster. It must be a valid domain administrator account. This
account is also used during the installation of the SQL Server 2000 virtual
server.
b. At least one account must be created that will administer the SQL Server
as well as the SQL Server Agent. This can be two separate accounts, and
does not need to be a domain administrator, but a valid domain account. If
desired, it can be the same as the account listed in the prior bullet
point, but it is helpful to keep the accounts separate.

For more information regarding this issue, please refer to the following
article:
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

I also found the following articles for your reference
How to Install SQL Server 2000 Clustering
http://www.sql-server-performance.com/sqlserver2000_clustering_install_main.
asp

269229 How to Manually Re-Create the Cluster Service Account
http://support.microsoft.com/?id=269229

SQL Server 7.0 and 2000 Clustering Resources
http://www.sql-server-performance.com/clustering_resources.asp

283811 HOW TO: Change the SQL Server or SQL Server Agent Service Account
http://support.microsoft.com/?id=283811

I am looking forward to hearing from you soon.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)