Re: error adding Windows group security to database

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 05/21/04

  • Next message: benn_at_sympatico.ca: "Logons without security" 
    Date: Fri, 21 May 2004 15:50:32 -0600

    sp_adduser is for backwards compatibility only - try using
    sp_grantdbaccess and sp_addrolemember. You can find more information
    on these procedures in books online.
    You can add a Windows group to the db_owner group using:
    EXEC sp_addrolemember 'db_owner', 'YourDomain\YourGroup'

    -Sue

    On Fri, 21 May 2004 12:42:23 -0700, "Andy"
    <anonymous@discussions.microsoft.com> wrote:

    >I'm trying to add a Windows 2000 group to a database with
    >db_owner rights using the following:
    >
    >-----
    >sp_adduser 'MyDomain\sql-admins', 'sql-admins', 'db_owner'
    >GO
    >-----
    >
    >I'm encountering the following error:
    >
    >-----
    >Server: Msg 15007, Level 16, State 1, Procedure
    >sp_adduser, Line 15
    >The login 'MyDomain\sql-admins' does not exist.
    >-----
    >
    >The login does exist though.
    >
    >Any help is appreciated.

  • Next message: benn_at_sympatico.ca: "Logons without security"

    Relevant Pages

    • Re: SQL Local Account Permission - Read Only on System Tables and
      ... Create a Windows group on the domain and have your developer logins added to ... VIEW SERVER STATE to that one login. ... can create your own server-level roles) and grant it VIEW SERVER STATE ...
      (microsoft.public.sqlserver.security)
    • Re: Is_Member problem : Does user belong to custom Group
      ... In active directory: 1 - Created in Active directory a Windows group named ... 'MyDomainName/MyApplReadOnly' as Login Name and the same as User ... We can create a ROLE in the database and add the users. ...
      (microsoft.public.sqlserver.security)
    • Re: Is_Member problem : Does user belong to custom Group
      ... - Added in Security/Logins the windows Group 'MyDomainName/MyApplReadOnly' referred as type 'Windows Group' with Defaultdatabase 'Master' ... Then configured the database Role Membership of this user by setting db_datareader and db_denydatawriter to true. ... for the current user returns 0 although he is referred in active directory as someone belonging to the the windows group Mydomainname\MyapplReadOnly ... There is a login, there is a user that mapped to the Login ...
      (microsoft.public.sqlserver.security)
    • Re: Howto troubleshoot login failure - State 11?
      ... DOMAIN\BizTalk Server Administrators | EDIMgmtDb | EDI Administrators | MemberOf ... If I create a login named DOMAIN\BTS01$ with only the 'public' role, and tries to logon I get this error: ... The reason seems to be that if I create the actual account in SQL Server, any Windows group memberships are ignored and the account itself must be granted the same rights as the Windows group. ...
      (microsoft.public.sqlserver.security)
    • Re: Error 18456: Login failed for user DOMAINuser
      ... I see, the thing is, there is no added Windows groups login in the SQL ... (Microsoft SQL Server, ... > Server through their membership in a windows group. ...
      (microsoft.public.sqlserver.security)