Hi,
First of all I would like to thank you in advance for all your time given to
my problem.
I'll try to explain our problem.
In our network we have several servers all with W2K SERVER.
SERVER 1 is DCP
SERVER 2 is DC
SERVER 3 is running SQL server standalone
SERVER 4 is running SQL server getting data from SERVER 2
SERVER 4 has several users defined as LOCAL and is supposed to get all AD
users but (and here is the problem) it doesn't.What I've found is that
SERVER 4 takes AD users from SERVER 3 and this one has some users missing
(all of them created after an specific date). The big problem is that the
users "most wanted" can't access OLAP cubes and I can't find a way to give
SERVER 4 those users.
Before that "day" SERVER 3 was a DC and now it isn't, so the AD information
is not replied to this server. Is there any way for SQL SERVER (or SERVER 4)
to get the whole AD information directly from SERVER 1 (or 2) without
promoting SERVER 4 to DC.
Thanks again
Alvaro Ruiz
URENDE, S.A.
alvaro.ruiz@.urende.es
Note: I'm not a expert in this so, I beg your pardon if I wrote something
that is not correct or if I have a wrong idea of how this works.Hi
Shutdown Server 3, Reboot Server 4 and see if you are getting the full list.
How was Server 3 turned into a stand alone server,after is was a DC? DCPROMO
or just a re-install without running DCPROMO first? If it was a re-install,
AD will still show it as a DC.
Regards
Mike
"Alvaro Ruiz" wrote:
> Hi,
> First of all I would like to thank you in advance for all your time given
to
> my problem.
> I'll try to explain our problem.
> In our network we have several servers all with W2K SERVER.
> SERVER 1 is DCP
> SERVER 2 is DC
> SERVER 3 is running SQL server standalone
> SERVER 4 is running SQL server getting data from SERVER 2
> SERVER 4 has several users defined as LOCAL and is supposed to get all AD
> users but (and here is the problem) it doesn't.What I've found is that
> SERVER 4 takes AD users from SERVER 3 and this one has some users missing
> (all of them created after an specific date). The big problem is that the
> users "most wanted" can't access OLAP cubes and I can't find a way to give
> SERVER 4 those users.
> Before that "day" SERVER 3 was a DC and now it isn't, so the AD informatio
n
> is not replied to this server. Is there any way for SQL SERVER (or SERVER
4)
> to get the whole AD information directly from SERVER 1 (or 2) without
> promoting SERVER 4 to DC.
> Thanks again
> Alvaro Ruiz
> URENDE, S.A.
> alvaro.ruiz@.urende.es
>
> Note: I'm not a expert in this so, I beg your pardon if I wrote something
> that is not correct or if I have a wrong idea of how this works.
>
>sql
No comments:
Post a Comment