Solved

Domain Enviroment File Shares

Posted on 2009-04-15
4
169 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:markj72000
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
Abhay Pujari earned 500 total points
ID: 24148621
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?
>>No.
And yes, you are right, you can manage network more efficiently in a domain environment. For SQL servr you need to enable Windows authentication only and add users (Windows users) to sql. Then grant them access to the databases.
0
 

Author Comment

by:markj72000
ID: 24194152
Ok, so just so I'm clear there is no way to integrate the active directory users and ou's into the sql server but no other server on the network will surfer this same issue?

thanks, sorry for the delay.

MJ
0
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24194265
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).
0
 

Author Comment

by:markj72000
ID: 24194676
Ok. cool.. thanks for your help.

Mark
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now