SQL 2000 Windows Authentication using AD Groups
- From: "Sean" <sean.ivey@xxxxxxxxx>
- Date: 16 Apr 2007 05:23:33 -0700
Please bear with me as I'm a bit new to SQL (although comfortable with
AD).
SQL 2000 running on Server 2k3 R2
One Active Directory domain also Server 2k3 R2
Users are connecting to DB Tables using Access 2003
Currently our users have access to a database through windows
authentication. Each user has their AD user account setup in SQL in
order to accomplish this. I'm trying to put the users into groups
(not sure if group type matters or not) to reduce the number of logins
that must be managed in SQL.
If I give the AD user account db_datareader, I have no issues. If I
give the AD group db_datareader and then remove the user account, I
get an error message whenever I open the linked table manager and try
to link it do the correct DSN.
The error message is "The Microsoft Jet database engine could not find
the object 'dbo_blahblah'. Make sure the object exists and that you
spell its name and the path name correctly.
Any ideas why this works if the user is granted access, but not when
the groups is? Any help is greatly appreciated!
.
- Follow-Ups:
- Prev by Date: Re: Do Windows Authentication SQL 2k5 Logins survive a sysprep?
- Next by Date: Re: SQL 2000 Windows Authentication using AD Groups
- Previous by thread: UNSAFE ASSEMBLY problem
- Next by thread: Re: SQL 2000 Windows Authentication using AD Groups
- Index(es):
Relevant Pages
|
|
