[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


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

Posted on 2008-10-13
Medium Priority
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 1500 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.
Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.


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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

650 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