Part 1)
We are configuring a brand new server with fresh installation of all
software. We have installed NTServ4.0 SP1 (not a PDC or BDC) and SQL6.5
SP2. Our NT Networking Protocol is TCP/IP. Our SQL Host Protocol is
Multi. We are using Integrated Security Mode.
We worked at the console of the server. Using UserMgr for Domains, we
created several new local groups, and pulled several Domain User IDs into
each. We went into SQL Security Manager, went to the Grant Admin Privilege
screen and selected local groups. The list showed all of NT's predefined
Local Groups (ie. Administators, Users, Backup Operators) but not our new
Local Groups (SQLAdmin, SQLUser). I have seen pictures in various books
(including Books Online) showing that this can be done, but I must be
missing something. Help!!!
One hunch - Do I have to reboot in order for the new groups to become
visible to services or applications?
Part 2)
Responsibility for security in our organization is divided - one group
handles domain security (New Users), and I am responsible for security on
this (and several future) SQL Server(s). I anticipate the other group will
create new domain IDs, then I will add these IDs to the Local Groups
(SQLAdmin, SQLUser).
Question) After the initial mapping of these Local Groups to SQL Security
(SQLAdmin --> Admin(sa), SQLUser --> Users), will the ongoing addition
(thru NT) of IDs to these groups result in the new IDs showing up in the
SQL Enterprise Manager 'Logins' list, from which I can grant database
privileges?
Thanks