nt group in cluster

From: Gabriel (anonymous_at_discussions.microsoft.com)
Date: 03/21/05

  • Next message: Julie: "Re: Log File Backup and Log Shipping" 
    Date: Mon, 21 Mar 2005 07:26:52 -0800

    Hi!

     Can anyone help with adding NT user group to sql server
    logins (with sys admin role)? I have two node active-
    pasive cluster (SQL Server 2000 Ent.edition, W2k advanced
    server). IŽd like to remove the builtin group
    adminstrators (from sql server instance), and add new
    group to logins in sql server, but I am not sure how to
    do this. What happens if I add group of first node, and
    failover occurs? Can I create "cluster" NT group?

    Thanks for help!

  • Next message: Julie: "Re: Log File Backup and Log Shipping"

    Relevant Pages

    • Re: System Administrator Implied Permissions
      ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server 2005 Login Problem
      ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
      (microsoft.public.sqlserver.clients)
    • No Application Logins Allowed - SOX
      ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
      (microsoft.public.sqlserver.security)
    • Re: Windows permissions to run Jet OLEDB 4.0
      ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
      (microsoft.public.data.oledb)
    • Re: End User Security Administrator for a Intranet Application
      ... If you are on SQL Server 2000, ... server role can change passwords and add logins. ... >role 'sysadmin' inorder to create logins, ...
      (microsoft.public.sqlserver.security)