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
224 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
  • 4
  • 3
7 Comments
 
LVL 6

Accepted Solution

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

Author Comment

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

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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

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

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

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