• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • 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

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.

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