Setting up a File Server on W2K advanced server which will run MS SQL 2000 with no internet connections

Posted on 2008-10-13
Last Modified: 2013-11-05
I have 15 computers which will be connecting to W2K Advanced Server w/MS SQL 2000.  There is no internet connections.  What is the best way to setup this server as a dedicated server?  Don't really understand how domain works.  
Question by:reikolayman
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3

Accepted Solution

powercram earned 500 total points
ID: 22707737
If the users are only accessing SQL you may not need a Windows (Active Directory) domain.  Otherwise run dcpromo (from the command line) and follow the wizard to create a new domain in a new forest.  Join all your workstations to the domain.  Create user accounts for your users in the domain.

Author Comment

ID: 22707770
How do you join the workstations to the domain?  Am I prompted with the wizard

Expert Comment

ID: 22707954
Assuming they are W2K or XP right-click My Computer, select Properties, Computer Name tab.  Click the Change button to either change the computer name or join domain.  When joining the domain you will be prompted for an administrative user's credentials.
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.


Author Comment

ID: 22708106
Will I need to create user accounts on the server first.  Then join the computers.

Expert Comment

ID: 22710621
Doesn't matter which order it's done, they just both need to be done before a user can logon through their computer to the domain with their new account.  

In order to change the domain/workgroup association you need to have administrative rights on the workstation.  Navigate to the join domain option using the steps above.  When attempting to join the domain you will be asked for a domain account with administrative privileges.  You will have to do this from each workstation.

Either before or after joining the computers to the domain you will open (on your domain controller / Active Directory server) Active Directory Users and Computers and create the respective user accounts.

Author Comment

ID: 22763936
The one question I asked that has not been answered yet isl:

If I setup this one and only server up as a domain controller and it does not have internet access and never will, can I still set it up as a domain controller?

Author Comment

ID: 22826407
Does anybody monitor these questions?  I still have not had my question answered.  
Hello, hello, hello.
Can you set up a domain controller without internet access?  If so, explain.

This is the 3rd time I've repeated this question on this post.  

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Know what services you can and cannot, should and should not combine on your server.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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