Using Windows Groups

From: John M Barr (jbarr@toobrands.com)
Date: 12/23/02 

From: "John M Barr" <jbarr@toobrands.com>
Date: Mon, 23 Dec 2002 10:28:18 -0500

I created a Domain Local Security Group and added a user to it. Then went
into SQL Server 2000, and added the Security Group and granted DataReader
access to a database. He gets denied access everytime he tries to connect.
If I just add him as a user, with DataReader access, he can connect. I would
prefer to have the Security Groups. Cna anyone explain why this doesn't
work?

Relevant Pages

  • Re: Using Windows Groups
    ... rights take effect. ... Did you do that before attempting to access SQL Server ... and added the Security Group and granted DataReader ...
    (microsoft.public.sqlserver.security)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... The security group SQLServer2005SQLBrowserUser$Computername shall be ... You can refer to the SQL Server 2005 Readme and installation requirements ... From this point the install completes successfully. ... SBS Monitoring Error Log ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Access Help!!!
    ... I created new login and chose the security group ... > user belongs to, ... >> This is my first SQL Server setup and I am having some problem. ...
    (microsoft.public.sqlserver.setup)
  • What rights do Clients Need?
    ... I am running SQL Server 2000 Std SP-3 ON Windows Server 2003. ... know the minimum security required to access the data on the SQL server. ... I have finally tracked it down to this specific security group. ... BTW I have not enabled the force SSL, however the SQL server does have an ...
    (microsoft.public.sqlserver.security)
Quantcast