Re: Requirements for non-administrative service account for clustered SQL 2000

Thanks for your comments but I eventually cracked it with the help of
this article:
http://www.sqlservercentral.com/columnists/ckempster/sql_server_security_printversion.asp

I simply followed the steps in here for assigning file and registry
permissions on both nodes and removed the service account from the
local Adminstrators group when I'd finished. Works a treat.

Note that the service account needs read permissions to the whole of
the drive with the master and TempDB devices not just the folder they
are in and full control on the folders containing the data devices.

.

Relevant Pages

  • Re: Windows Service - folder permissions
    ... Are you talking about giving the permissions on that folder to the Network ... I am using the Network Service account for the ServiceProcessInstaller. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: How do you change the e-mail address of an email enabled list?
    ... Regarding permissions... ... I suppose the service account has the correct ... (I assume this since I can mail enable a folder and the ... why would it have trouble re-creating it? ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Minimum NTFS Permissions - Theres such a thing???
    ... ?2001 Microsoft Corporation. ... HOW TO: Set Minimum NTFS Permissions Required for IIS 5.0 to Work WGID:198 ... " List Folder Contents" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The fact that the tech support is based in India has nothing to do with the ... If so you may want to leave this folder alone. ... down to all children folders because i can set those permissions to ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The only computers i fix are my own. ... If so you may want to leave this folder alone. ... it includes all subdirectories with inherited permissions. ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)