?
Solved

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

Posted on 2008-10-13
7
Medium Priority
?
230 Views
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.  
0
Comment
Question by:reikolayman
[X]
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
7 Comments
 
LVL 7

Accepted Solution

by:
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.
0
 

Author Comment

by:reikolayman
ID: 22707770
How do you join the workstations to the domain?  Am I prompted with the wizard
0
 
LVL 7

Expert Comment

by:powercram
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.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:reikolayman
ID: 22708106
Will I need to create user accounts on the server first.  Then join the computers.
0
 
LVL 7

Expert Comment

by:powercram
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.
0
 

Author Comment

by:reikolayman
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?
0
 

Author Comment

by:reikolayman
ID: 22826407
Helllooooooooooooooo,
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.  
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Case Summary: In this Article we introduce the new method to configure the default user profile using Automated profile copy with sysprep rather than the old ways such as the manual copy of a configured profile to default user profile Old meth…
Know what services you can and cannot, should and should not combine on your server.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
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: …

770 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