Re: No users/groups can login to SQL Server unless part of sysadmin

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Richard Mueller [MVP]" <rlmueller-nospam@xxxxxxxxxxxxxxxxxxxx>
Date: Thu, 29 Jan 2009 12:25:37 -0600

<spiyush12@xxxxxxxxx> wrote in message
news:335de5d9-48d0-46b3-8bd3-e7b2a13a1d2d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

We have SQL server 2005. We have mixed mode authentication.. We have
created groups in Active Directory. I created a login for the group
and mode is Windows authentication.

When I create ODBC connection is does not let me select any database.
However if I specify the group as part of sysadmin then I can connect
to the server/database/tables...

I am new ot SQL Server.. Any help would be appreciated..

To use Windows Authentication, assign a database role to the AD group. No
need to use SQL logins. All members of the AD group will get the permissions
assigned to the database role. I create my own role in the database and
assign the permissions needed. See Books On Line for details.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

.

Follow-Ups:
- Re: No users/groups can login to SQL Server unless part of sysadmin
  - From: spiyush12

References:
- No users/groups can login to SQL Server unless part of sysadmin
  - From: spiyush12

Prev by Date: Re: Creating a database on a local Sql Server Express
Next by Date: Re: Creating a database on a local Sql Server Express
Previous by thread: No users/groups can login to SQL Server unless part of sysadmin
Next by thread: Re: No users/groups can login to SQL Server unless part of sysadmin
Index(es):
- Date
- Thread

Relevant Pages

Re: No users/groups can login to SQL Server unless part of sysadmin
... created groups in Active Directory. ... I created a login for the group ... To use Windows Authentication, assign a database role to the AD group. ...
(microsoft.public.sqlserver.setup)
Re: archive database rights
... Tolga, ... If you make the login a member of the db_backupoperator database role, ... > I want a user in my domain (or in SQL) to access to SQL tables "only" for ...
(microsoft.public.sqlserver.security)
RE: old question about login, but no help from the existing threads
... > - Windows Authentication only ... Not associated with a trusted SQL ... > My system and configurations: ... > Permit in Database Role all checked. ...
(microsoft.public.sqlserver.security)
Re: You are not the owner specified for the object INFORMATION_SCHEMA...
... Just wanted to add that login with such names are ... And it is not a member of sysadmin server role db_owner ... database role, right? ... trying to execute the following statement, ...
(microsoft.public.sqlserver.programming)
Re: How do I drop DBO access to a DB?
... Because those users are members of db_owner database role or even sysdamin ... separate login to the instance ... How do I deny them access to a particular DB that they created? ...
(microsoft.public.sqlserver.security)