Very Computer

1. Relationship between sql server , local machine and Domain groups and ids

In the the sql administrators companion there is a chapter on managing security.
This I am trying to understand as related to our environment.

We are looking at having multiple domains a federal domain and
then departmental domains, there will be some trusting between them
but it has not been fully decided whether its full trust both ways
or just one way or both ways partial.

The administrators of the federal domains will not be allowed
be allowed sa privileges on our sql server which is in the federal domain
, nor will they or others be allowed sa priviliges in our departmental sql
server. The manual says
'create one administrator-level group and one or more user-level groups for
the accounts that will access sql-server.....'

are they talking about sqlserver groups, local machine groups, or
domain groups?

When I use sql security manager I for users I can see just 1 group
Domainname (that the machine is in, not default domain as set in enterprise manager
for that database)/Domain Users. I can then click on this group and select users
independantly. I cant see any other groups, should I be able to? how do
I enable sql security manager to see these other groups?

If there is a trust relationship with another domain should I be able to select
users from the other domain and make it so they can connect to sql server.

We are using mixed security.
Anne    

2. Updated version of MSDE 1.0????

3. NT Access to Local Groups w/Global IDs

4. error 37000 syntax error or access violation

5. Remapping/Copying SQL Logins from NT Local Groups to Domain Global Groups

6. Bangkok-96: Last CFP

7. renaming nt server with sql 7 loaded with original name

8. Variable declaration in views

9. How to rename dimension name from tabel name( local cube)

10. Howto Rename Local Server to a Named Instance (2000)

11. Server to change name - what impact to SQL Server

12. using windows NT Server Local groups