AD ACL Cache

This is for SQL 2005 RS and win 2003 AD
I created a number of roles in Active Directory to limit
access to reports in the Management Portal for Job X. Initially, I created
a role for each report and then added groups to those roles. After getting
this
all set, I determined that it would probably be a better idea to set up more
general report roles that could encompass groups of reports rather than
individual reports. I deleted most of the original roles I created and
created
new roles to serve this new structure. Now, when I hit AD for a list of
groups
to set permissions, I am returning the original roles that I have since
deleted
and the new roles I created are not in the list. I am assuming this has
something to do with a local cache on my machine, but I do not know how to
refresh this cache from Active Directory. I have done a ton of searching on
Google trying to solve this problem and so far cannot find anything that
seems
to speak to the issue I am having. There is a good possibility that roles
will
be added or changed as this program gets rolling and if I'm having this
issue during the debug process it seems logical that end users may
experience
the same difficulties if I cannot resolve this before launch.

Many Thanks
Mike

I have had similar issues with users and groups not being immediately
available on a SQL Server if I understand your questions correctly. Not
sure why, but couple hours later things are cleaned up, so I assume there is
a service that is in the background that cleans this up. Sorry I have no
technical explanation only similar experience if I understand your question
correctly.

If you are still experiencing this I would repost this in the SQL NewsGroup.

--
Paul Bergson
MVP - Directory Services
MCITP - Enterprise Administrator
MCTS, MCT, MCSE, MCSA, MCP, Security +, BS CSci
2008, Vista, 2003, 2000 (Early Achiever), NT4
Microsoft's Thrive IT Pro of the Month - June 2009

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewGroups. This
posting is provided "AS IS" with no warranties and confers no rights.
"Miadf" <> wrote in message
news:%...
> This is for SQL 2005 RS and win 2003 AD
> I created a number of roles in Active Directory to limit
> access to reports in the Management Portal for Job X. Initially, I created
> a role for each report and then added groups to those roles. After getting
> this
> all set, I determined that it would probably be a better idea to set up
> more
> general report roles that could encompass groups of reports rather than
> individual reports. I deleted most of the original roles I created and
> created
> new roles to serve this new structure. Now, when I hit AD for a list of
> groups
> to set permissions, I am returning the original roles that I have since
> deleted
> and the new roles I created are not in the list. I am assuming this has
> something to do with a local cache on my machine, but I do not know how to
> refresh this cache from Active Directory. I have done a ton of searching
> on
> Google trying to solve this problem and so far cannot find anything that
> seems
> to speak to the issue I am having. There is a good possibility that roles
> will
> be added or changed as this program gets rolling and if I'm having this
> issue during the debug process it seems logical that end users may
> experience
> the same difficulties if I cannot resolve this before launch.
>
> Many Thanks
> Mike
>
>
>
>