Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 891
  • Last Modified:

changing from workgroup to domain in windows 2003 server

i have a windows 2003 server which iam using it as a application server and it is in domain. i have another machine it also has windows 2003 server which we are using as a production database server, it is in workgroup. i have another machine which is having windows 2000 server which is in different domain. i need to make this windows 2000 server machine as a standby database, but production database serveris in workgroup and standby database is in domain. it is not allowing me to make windows 2000 server machine as a standby database. so can i change the production database server to a domain, is it possible? give me your valuable suggestion. it shouldn't affect to database and application server. plz give me your suggestions.
0
anand_2000v
Asked:
anand_2000v
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Okay, I think I understand what you are trying to say there... (once I added a couple of commas and periods).

You need to decide whether you are going to have a domain environment or a workgroup one.  You can't really have both.  There are MANY reasons to have a domain environment, mostly for security and centralized management.  If your database is so valuable that you want to have a "standby" machine for it, I would think it would be valuable enough for you to provide proper security for it and a solid patch management plan for it as well.  

Take a look at these guides and then you can decide what you want to do:

http://www.microsoft.com/windowsserver2003/technologies/directory/activedirectory/default.mspx

Jeff
TechSoEasy

0
 
NzarthCommented:
You should be able to DCPROMO the database server without any effect on the actual database itself.  The only problem that I can think of is that you will need to repoint the clients to the database as they will be configured to look at the database within a workgroup instead of the domain.....(could be a server that needs redirecting depending on who talks to the database and how they do it).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now