markj72000
asked on
Domain Enviroment File Shares
This is probably a silly question but i cant seem to wrap my mind around it and haven't found any results on Google that satisfy my question. I'm pretty new to domain environments so please bare with me. :)
If someone could help me understand how file permissions are controlled in a domain environment. We are a pretty small company and only have 1 server that acts as the DC, File Server, DHCP, DNS, SQL. Windows 2003 Enterprise, not SBS.
I just recently got a second smaller server that i was planning on moving the DC to. I should also mention that i just recently moved the SQL server to a virtual machine on the same server which seems to run much faster now. I'm running vmware server (not esxi).
When i did the sql server move to the virtual machine and had the SQL server join the domain i sort of expected to be able to control permissions for the sql server using the existing ou's that i had setup on the DC but i ended up having to setup everyone again on the sql server since i couldn't view the dc ou's from the SQL server.
So before i move the DC to it's own machine which i know i need to do. Will i have the same problem with file permissions on the existing server once i demote the dc and move it to the other server?
I'm just trying to understand if that's how it is supposed to be or am i completely missing the boat here. I thought 1 of the many benefits of the Domain environment was so i could manage most of the network computers from the DC and not have to deal with all the separate settings on each machine.
thanks,
Mark
If someone could help me understand how file permissions are controlled in a domain environment. We are a pretty small company and only have 1 server that acts as the DC, File Server, DHCP, DNS, SQL. Windows 2003 Enterprise, not SBS.
I just recently got a second smaller server that i was planning on moving the DC to. I should also mention that i just recently moved the SQL server to a virtual machine on the same server which seems to run much faster now. I'm running vmware server (not esxi).
When i did the sql server move to the virtual machine and had the SQL server join the domain i sort of expected to be able to control permissions for the sql server using the existing ou's that i had setup on the DC but i ended up having to setup everyone again on the sql server since i couldn't view the dc ou's from the SQL server.
So before i move the DC to it's own machine which i know i need to do. Will i have the same problem with file permissions on the existing server once i demote the dc and move it to the other server?
I'm just trying to understand if that's how it is supposed to be or am i completely missing the boat here. I thought 1 of the many benefits of the Domain environment was so i could manage most of the network computers from the DC and not have to deal with all the separate settings on each machine.
thanks,
Mark
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No. You can create users manually. You have a option of group though. Put your users in a group and add that group in SQL server(Create new login and add group).
ASKER
Ok. cool.. thanks for your help.
Mark
Mark
ASKER
thanks, sorry for the delay.
MJ