how to setup the 2nd windows 2003 server

currently i have one windows 2003 server running as web server, domain controller, database server, and exchange server. I purchased a new windows 2003 server and want to move the database to this new server. I want to move the SQL server and ERP system to this new server.

Any idea on how to setup? Any help is appreciated.

Thank you

Elaine
Elaine_ShiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TheCleanerCommented:
1.  Install the OS and drivers
2.  keep it in a workgroup and update all the critical patches, and SP1 from Windows Update
3.  Get virus scanning on it
4.  Add it to the domain
5.  Install SQL server
6.  Move/migrate the SQL databases over using SQL enterprise manager
7.  Migrate the ERP system (not sure how on this, it's dependent on the ERP system you are using).

That's about it, in a quick overview.

Obviously the ERP clients and database clients will need to point those client apps to the new server at that point.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Elaine_ShiAuthor Commented:
on the ADUC located on the first server, should I add the new server name under the computers or somewhere first?

then join to domain?


0
rsivanandanCommented:
Nope, when you do the 4th step mentioned by TheCleaner above, it will get added to the domain.

Cheers,
Rajesh
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

TheCleanerCommented:
I think it's easier to add it to the domain, then drag it out of the default container in ADUC into the "servers" OU or wherever.

But that's just me.
0
Elaine_ShiAuthor Commented:
is it the same as adding a windows client pc to the network?
0
rsivanandanCommented:
Yes.

Cheers,
Rajesh
0
Elaine_ShiAuthor Commented:
I have the final question here,

when you add a pc client to the domain, do you usually go to AD and add new computer first, then go back to the client pc: my computer>properties>chang>join domain? or just directly join domain on the client pc?
0
rsivanandanCommented:
You can do it either way. But I do it the way TheCleaner does. I just go to the PC and add it to the domain.

Cheers,
Rajesh
0
Elaine_ShiAuthor Commented:
Thanks all for your help.
0
TheCleanerCommented:
Very welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.

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.