Re: multiple domain access
From: Ryan LaNeve (ryan@nolanevespam.com)
Date: 11/26/02
- Next message: Gary Jones: "SQL Server 7.0 Upgrade Wizard"
- Previous message: Stamey: "Re: Need some security suggest"
- In reply to: Ian: "multiple domain access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Ryan LaNeve" <ryan@nolanevespam.com> Date: Tue, 26 Nov 2002 01:59:53 -0500
"Ian" <ian.mackenzie@lmco.com> wrote in message
news:1590801c2949d$65f7f340$89f82ecf@TK2MSFTNGXA01...
> Greetings;
> We have a large, complex enterprise, made up of several
> domains. In each domain, we have a global group of the
> smae name,i.e. DOMAIN1/groupA, DOMAIN2/groupA. SQL 2000
> sets up security and database access for the first SQL
> account created for these groups just fine. However, when
> I go to create the next doman group login, SQL replies
> politely but firmly that that user "groupA" already
> exists. SQL creates the account, but I can't grant access
> to the same database. I realize this will not be such a
> problem when Active Directory is fully implemented, but
> what can I do for now (other than rename the global
> groups)?? Any reply is welcome.
While Jasper's suggestion will work, an alternative is to just prefix the
name when adding it to the database (which in my experience, it does
automatically when adding the group via EM). Once the login has been added
to the server itself, open the properties for it and select the "Database"
tab. Find the database you wish to grant access to, check the box, and then
change the default user name from "groupA" to "DOMAIN2\groupA", or whatever
is appropriate. We've added several "Domain Users" groups for various
domains all to the same databases by doing this. Again - EM should prefix
the group automatically if a group with the same name has already been added
to the database.
Good luck,
Ryan LaNeve
- Next message: Gary Jones: "SQL Server 7.0 Upgrade Wizard"
- Previous message: Stamey: "Re: Need some security suggest"
- In reply to: Ian: "multiple domain access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
