Re: Security and access rights using local and global groups

From: Clifford Heath (no_at_spam.please)
Date: 03/02/05 

Date: Wed, 02 Mar 2005 22:55:08 +1100

Clifford Heath wrote:
> Can anyone answer this question please?

I've answered it myself. The answer is that everywhere the technical
articles talk about local groups, they mean groups local to the
computer system running SQL Server, not domain local groups.

Although it's possible to add access rights for Domain Local groups
into SQL server, they are completely non-functional - and nothing
gives an error message (other than "permission denied"). Sigh. And
here I was beginning to believe that this was a seriour professional
product.

Hopefully this information is useful to someone, because it sure feels
like I'm talking to myself.

Clifford.

Relevant Pages

  • Re: 2005 Cluster Install Error
    ... Domain Local Groups were introduced in Windows 2000 Active Directory ... > Resource groups, and, apparently, SQL Server 2005 security groups. ... there is a new requirement that not only does the Installation ... >>> 3.5.15 Corrections to the Names of Security Groups Created During Setup ...
    (microsoft.public.sqlserver.clustering)
  • Re: NT4 BDC to Win2k3 server
    ... Well, if i now understand correctly, you are saying you want to upgrade your ... As long as you still have a PDC, the domain local groups will ... > Win2k3 server be a member server in the NT4 domain. ...
    (microsoft.public.windows.server.migration)
  • Re: 2005 Cluster Install Error
    ... solution of creating machine local groups to which I add Domain Global ... given they do document the machine local groups as SQL Server security ... > I can see the need to promote Machine Local Groups to Domain Local Groups ... > when we are talking about clusters because the level of scope. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 2005 Cluster Install Error
    ... There are DOMAIN Global groups, LOCAL groups, Cluster ... Resource groups, and, apparently, SQL Server 2005 security groups. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 2005 Cluster Install Error
    ... > solution of creating machine local groups to which I add Domain Global ... > given they do document the machine local groups as SQL Server security ... >> I can see the need to promote Machine Local Groups to Domain Local Groups ... >> when we are talking about clusters because the level of scope. ...
    (microsoft.public.sqlserver.clustering)
Loading