SQL Server SP3: Failed to apply

From: Youcheng (yzhang5@cox.net)
Date: 02/08/03 

From: "Youcheng" <yzhang5@cox.net>
Date: Sat, 8 Feb 2003 07:05:33 -0800

Hi,

I always received "Access is denied" error when applying
SQL Server SP3 to a clustered SQL Server 2000 (SP2) on a
Windows 2000 cluster (a Domain controller running SP3)
with two nodes though either administrator or SQL server
owner account (a member of Administrators group) is
provided on Remote Information Page. The detailed message
is as follows:
"The specified account can not be validated to have
administrator rights on xxxxxx. An error occurred: (5).
Access is denied."

Any help is greatly appreciated!

Youcheng

Relevant Pages

  • Re: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... This has nothing to do with SQL Server and this is an expected behaviour of Windows Vista operating systems. ... Cause of those popups and normal-user-like acting is some new security system called User Account Control. ... It all seems to be related to security things, even though I am an administrator. ...
    (microsoft.public.sqlserver.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: Service Accounts on SQL Server, Best Practices
    ... SQL Server and SQL Server Agent service accounts do not need to be a local administrator or domain administrator for Failover Clustering on Windows 2000 ... If the service account for SQL Server is not an administrator in a cluster, the administrative shares cannot be deleted on any nodes of the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)