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
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
227 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
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

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Remote Desktop Protocol or RDP has become an essential tool in many offices. This article will show you how to set up an external IP to point directly to an RDP session. There are many reasons why this is beneficial but perhaps the top reason is con…
Know what services you can and cannot, should and should not combine on your server.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

860 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