multiple domain access

From: Ian (ian.mackenzie@lmco.com)
Date: 11/25/02 

From: "Ian" <ian.mackenzie@lmco.com>
Date: Mon, 25 Nov 2002 08:12:06 -0800

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.

Relevant Pages

  • Re: SQL 2005 express security issue
    ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ... You do not have to use the "sa" account and it's not recommended using this account because every hacker knows that SQL Server has a built-in sysadmin account which is called "sa". ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... Ekrem Onsoy ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... In your place I would go trough database and have mirrored accounts in SQL ... you can create views on SQL server to filter out ... Grant ASPNET account logon rights to SQL server and limit ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Problem connecting to SQL2000...
    ... problems with their current sql installation. ... >Install without database engine (that way you could ... >account is the database access account. ... >Microsoft MVP - SharePoint Portal Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: multiple domain access
    ... we have a global group of the ... > sets up security and database access for the first SQL ... Find the database you wish to grant access to, check the box, and then ...
    (microsoft.public.sqlserver.security)