how to give authenticated users access to database

Author Message
jperkins750
  • Total Posts : 52
  • Scores: 9
  • Reward points : 0
  • Joined: 5/7/2002
how to give authenticated users access to database - Friday, November 22, 2002 3:47 PM
0
I need to give users from a trusted domain access to a database.

I have tried to add the authenticated users group as a login in SQL, but it doesn' t show up.

What is the best way to allow anyone authenticated to the domain to access the database?

Thanks!
jperk
MCSE, CCNA, CCSE

Guest
Check this - hope this helps!!! - Friday, November 29, 2002 12:00 AM
0
from BOL:

Adding a Windows User or Group
Microsoft® Windows NT® 4.0 and Windows® 2000 accounts (users or groups) must be granted permissions to connect to an instance of Microsoft SQL Server™ before they can access a database. If all members of a Windows NT 4.0 or Windows 2000 group will be connecting to an instance of SQL Server, you can grant permission to the group as a whole. Managing group permissions is much easier than managing permissions for individual users. If the group should not be granted permission collectively, grant permission to connect to an instance of SQL Server for each individual Windows NT 4.0 or Windows 2000 user.

Users
When granting a Windows NT 4.0 or Windows 2000 user access to connect to an instance of SQL Server, specify the Windows NT 4.0 or Windows 2000 domain or computer name to which the user belongs, followed by a backslash, and then the user. For example, to grant access to the Windows NT 4.0 or Windows 2000 user Andrew, in the Windows NT 4.0 or Windows 2000 domain LONDON, specify LONDON\Andrew as the user name.

Local and Global Groups
There are several types of Windows NT 4.0 and Windows 2000 groups, including global and local:

Global groups contain user accounts from the Windows NT 4.0 or Windows 2000 domain in which they are created. Global groups cannot contain other groups or users from other domains and cannot be created on a computer running Microsoft Windows NT 4.0 Workstation or Microsoft Windows 2000 Professional.


Local groups can contain user accounts and global groups from the domain in which they are created and in any trusted domain. Local groups cannot contain other local groups.
Additionally, Windows NT 4.0 and Windows 2000 have predefined, built-in local groups (for example, Administrators, Users, and Guests).

When granting a Windows NT 4.0 or Windows 2000 local or global group access to connect to an instance of SQL Server, specify the domain or computer name the group is defined on, followed by a backslash, and then the group name. For example, to grant access to a global group called SQL_Users, in the LONDON domain, specify LONDON\SQL_Users as the group name.

To grant access to a Windows NT 4.0 or Windows 2000 built-in, local group, specify BUILTIN instead of the domain or computer name. To grant access to the built-in Windows NT 4.0 and Windows 2000 local group Administrators, specify BUILTIN\Administrators as the group name.

For more information about these accounts, see the Windows NT 4.0 and Windows 2000 documentation.
\ / /
\\\' , / //
\\\//, _/ //,
\_-//' / //<,
\ /// > \\\`__/_
/,)-~>> _\` \\\
(/ \\ //\\
// // \\\
(( ((

dhite
  • Total Posts : 150
  • Scores: 10
  • Reward points : 7480
  • Joined: 6/6/2001
RE: how to give authenticated users access to database - Thursday, December 12, 2002 6:02 PM
0
Did Alexzander get you going J?

D

Guest
RE: RE: how to give authenticated users access to database - Friday, December 13, 2002 4:30 AM
0
I think so, Don, because BOL cannot have a mistakes
\ / /
\\\' , / //
\\\//, _/ //,
\_-//' / //<,
\ /// > \\\`__/_
/,)-~>> _\` \\\
(/ \\ //\\
// // \\\
(( ((

pcupina
  • Total Posts : 7
  • Scores: 1
  • Reward points : 0
  • Joined: 9/17/2001
RE: how to give authenticated users access to database - Friday, December 13, 2002 5:35 AM
0
I have had the same issues. WHat I did was create a local group on that server with the types of rights that are needed. This solved my issue.

jperkins750
  • Total Posts : 52
  • Scores: 9
  • Reward points : 0
  • Joined: 5/7/2002
RE: how to give authenticated users access to database - Friday, December 13, 2002 7:33 AM
0
We created a SQL login that was linked to the Domain Users group. Then gave this login the rights on the databases that we wanted. Not authenticated users, but it works.

Thanks for all of your help.